BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Excel 2013 contains radical changes to charts, pivot tables and the user interface. This review explains all the new features of Excel 2013
Posted by Andy Brown on 30 January 2013
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Excel 2013 - Changes to Charts
I think charts went backwards in Excel 2010, and it appears Microsoft agree, as there are more changes to charting in Excel 2013 than anything else.
Recommended charts
If you select a block of data and click on the new Recommended Charts icon on the INSERT tab of the ribbon, Excel wil suggest sensible charts to fit your data:
Excel recommends a series of charts (you can scroll between them, and click on any which takes your fancy to create an embedded chart).
A good idea, although for the above chart I would have preferred to see Excel suggest a combination chart with the total plotted against a separate axis.
Quick ways to change charts
When you click on any charts, there are quick ways to add/delete parts of it, or format it:
You can use these icons as shown below to customise charts quickly.
You can choose which elements of the chart should show up, and how:
Each chart element has a custom submenu - here we're configuring the chart title.
You can quickly change the style and colour of your charts:
Here we're choosing a different style for the chart.
Finally, you can change which data is being charted:
You can quickly exclude certain superheroes or clothing items from your chart!
Better chart formatting
That's an understatement. Here's an example - how to format a chart title:
The formatting task bars are now a delight to use.
Simpler chart ribbon
The Excel 2010 chart ribbons were ... pants. They're now much simpler, being condensed into two dedicated chart tabs:
Use the DESIGN tab to change the nature of the chart, or the FORMAT tab to change its format.
New combo chart type
We've asked for it ... and Microsoft have listened!
The new Combo chart type.
Better data labels
Chart data labels can now have different shapes:
Fancy a call-out data label anyone?
I think this might make a chart look gimmicky:
Are these labels really any clearer?
Chart animations
While on the subject of gimmicks, here's a bad one. When you change data, the chart updates using animation:
Think Batman needs more masks laundering? Press ENTER ...
When you press ENTER above to confirm the new data, the chart will update:
The chart caught in mid-update (I had to be quick with the screen capture).
A waste of programming time, in my opinion!
The final part of this blog (before the summary and recommendations page) will look at general changes which don't fit into any of the categories I've looked at so far.