You may have noticed that Excel gives every chart a unique number when it creates the chart. It is displayed in the Name Box in the left corner above the grid. You have the ability to change that name and make it more descriptive.
Tag Archives: charts
Stop Charts Resizing
Works with other graphic objects like text boxes
We’ve all been there, our charts are looking just right and then some one inserts a column or changes the column width and throws out all our perfectly proportioned charts.
Hide and Seek with Excel Charts
Hiding rows and columns
Charts have a behaviour that many people don’t realise. That behaviour can also be turned off. If you hide a row or column in the data range used by a chart, the values will also be hidden on the chart.
Chart Suggestions
When less is more
Just because you can, doesn’t mean you should. This applies to many thing in Excel and especially to charts. With charts the “less is more” philosophy works well. Have a look at the four charts in the image below.
Power BI – A Chart
The ultimate goal
Dashboard Charts are the ultimate goal of most Power BI reports, so let’s dive in.
Show Horizontal Axis Entries Below the Chart
Great for displaying negatives in a line or column chart
I learned about a chart Axis option in Excel during a recent webinar – thanks to one of the attendees. You can show the Axis entries below the chart – this is handy for column charts that display negatives.
When a Bar Chart is Better
Before and after charts
I was reading a magazine last week and a chart caught my eye. I thought I could improve it. I recreated it in Excel – its close to the original – see below – I didn’t quite match the column colour.
Excel Variance Analysis
An alternative charting technique
It is common in accounting to compare numbers. Either Actuals vs Budget or this year vs last year. There are different charts that people use for this comparison. How about plotting the variance instead?
Horizontal bullet chart in Excel
Excel Yourself article
Check out my follow up article and VIDEO on the ITBDigital website on how to convert a vertical bullet chart into a horizontal one.
Click here for full article and video.
For the original bullet chart post click here
These techniques are based on ones in the great book
Excel 2007 Dashboards and Reports For Dummies by Michael Alexander
Excel Bullet Charts [Video]
Excel Yourself Article
Check out my July 2014 article on Bullet charts on the CPA Australia ITBDigital website – click here to see the article. The video is below.
Bullet charts were developed by Stephen Few – see his pdf on bullet charts click here.
The technique is based on one used by Michael Alexander in his great book Excel 2007 Dashboards and Reports for Dummies by Wiley.
Excel and Grouping
The term grouping in Excel has many different meanings, probably more than any other term in Excel.
Re-Sizing Charts In Excel
How to get identically sized charts
When building dashboards in Excel you frequently need to have multiple charts that are exactly the same size. Luckily Excel makes this reasonably easy to achieve.
Slope Chart
How to show movement
This post is attempting to replicate a slope chart.
I took a standard Line chart as seen in the top of this image. And then used the Design Tab option Switch Row/Column to create the slope chart at the bottom of the image.
Handling graphics in Excel
Make the most of graphics
If you need to move or amend a lot of graphics at once Excel has a feature that can save you time and effort. It’s been around for a while, but it’s been hidden away in the latest few versions.
How to Improve an Excel Line Chart [VIDEO]
Before and after improvements
Line charts are frequently used in Excel but their default settings leave a lot to be desired. See the transformation of a standard line chart to a simpler and easier to read line chart.
Column vs Bar Charts in Excel [VIDEO]
Pick the best one for your data
A Column chart walks into a Bar chart … sorry, I couldn’t resist that. Column charts are one of the most popular and straightforward of Excel’s many chart types. Its close cousin is the Bar chart.
New Sparkline Charts in Excel 2010
Keep it small and simple
Excel’s Sparkline Charts
Sparkline charts are a new feature in Excel 2010. Sparkline charts are small cell-sized charts that are designed for dashboard reports. The chart sits inside a single cell and its size changes with the size of the cell, both height and width.