Saturday, February 13, 2021

Column Chart

 Column Chart

        You can create chart to compare data and view patterns and trends easily. We use column charts to compare values across few categories.

To create a column chart use these steps below....

  • Select the range of data that you want on chart.










  • Go to Insert tab ➤click on column chart from the charts group.






  • Insert any 2D or 3D column charts (here I choose stacked column chart)









  • Now excel immediately creates a chart and places it on the worksheet.









Chart elements

  • Here you add chat elements by clicking on the (+) sign near your chart. You can add remove or change chart elements such as the title, data table legend, gridlines.
  • Check or uncheck the boxes here to add or remove anyone.
        Note:( Make sure you click on the chart area to see these options)





















Chart styles
  • From chart styles you can add any chart style and color for your chart.



















Here you add colors for your chart











Chart filters

  • In chat filters you edit what data points and names are visible on your chart.



















Moving and resizing a chart / changing the chart type / changing the layout of chart/Insert Sparkline

No comments:

Post a Comment

Bubble chart in Excel

  Bubble chart in Excel:           Bubble chart show the relationships between sets of values.          Bubble chart compare at least three ...