Ok we aren’t going for a war but I want you to be killer at charting so I call the tools as arsenal… let’s begin

I travel a lot and train people on PowerPoint and Excel in companies and often I have found people either forgetting or not knowing the chart tools available to them, so I am dedicating this 3 part post to all of you who need more arsenal. Along the way I’ll keep pointing out the Excel 2007 v/s 2013 version differences

1. So, Where are these charts ?

In the Insert Tab

 Excel 2007

Know your chart arsenal 6Know your chart arsenal 1

Excel 2013

Know your chart arsenal 2

 

2. How many Chart Types ?

Excel 2007

Probably limitless, essentially because excel gives you the option of mixing the charts, for instance you can have a column chart and a line chart together in a single chart. But if you still want to zero down on a specific number of the available charts in excel .. the number is 58. Lets check them out .

Know your chart arsenal 3

More details on chart types can be read here

 

Excel 2013

  1. If you note the difference between 2007 and 2013 the number of sub categories have reduced (for good!). There were a lot of meaning less sub categories like pointed column charts which looked like rocket launchers .. who would use them in business presentations and dashboards? I would say that in 2013 Microsoft got wiser!
  2. Another difference is the combo option in the categories where you can combine 2 different charts. We’ll check that out later
  3. The 3rd good thing is that if you don’t know what chart type to select for your data, excel 2013 gives you some options (with commentary) in Recommended charts

Know your chart arsenal 4

Chart Recommendation by Excel 2013

Know your chart arsenal 5

 

A snapshot (number of charts in each category)

Know your chart arsenal 6

 

3. How do I create a chart ?

You can simply select your data and Insert the relevant chart type in your data. Take a look Know your chart arsenal 6Know your chart arsenal 6

Know your chart arsenal 6,1

 

Coming up Next

  1. Adding data to your charts
  2. Adding chart elements

 

Stay tuned ..



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI