Info, Tutorials, Downloads, Audio Books, Videos, Ebooks and More

Tuesday, September 27, 2016

Chart In Excel

Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.
To create a chart in Excel, you start by entering the numeric data for the chart on a worksheet. Then you can plot that data into a chart by selecting the chart type that you want to use on the Office Fluent Ribbon (Insert tab,Charts group).
Chart In Excel

This is a sample data we will create chart using this data

Chart In Excel

  1. Select cells A3 to D6. You must select all the cells containing the data you want in your chart. You should also include the data labels.
  2. Choose the Insert tab.
  3. Click the Column button in the Charts group. A list of column chart sub-types types appears.
  4. Click the Clustered Column chart sub-type. Excel creates a Clustered Column chart and the Chart Tools context tabs appear.

Chart In Excel



Check These Also


No comments:

Post a Comment

Dear Readers,

Great !! You've decided to leave comment for us. Let's make meaningful conversation by adding your name.

Please note that,

Comments deemed to be spam or questionable spam, including profanity and containing language or concepts that could be deemed offensive will be deleted.
Including a link to relevant content is permitted, but comments should be relevant to the post topic.