08 6210 8500
There are lots of ways to add a new data series to an existing Excel chart. Here are what we suggest are the two easiest ways: Method 1: Copy & Paste Great if your data series aren't in a table or aren't adjacent to each other. 1. Select your data (including the heading) and copy this [...]
Creating a Waterfall Chart in 5 Steps By Wyn Hopkins A waterfall chart is a great way of illustrating the causes of differences between two data points. The most common being Actual v Forecast or Current Year v Prior Year. It can be quite a tedious manual process to create this chart, [...]
Stop zeroes displaying on line Charts I have a line chart which has all the months of the year displayed. Each month is linked to a data cell. This means that future months display zero values. The line chart drops down to zero for these future months. Instead of having to change the chart [...]
Using Text Boxes on Charts I use text boxes to put notes onto charts. But if I move the chart the text boxes don't move with it. Is there an easy way to achieve this? By Neale Blackwood There are a couple of solutions to this problem. The first uses the Ctrl key to [...]
REPT function - create a Cell chart Is it possible to use a cell to display a bar indicator like a bar chart, based on another cell's value? By Neale Blackwood The REPT function allows you to repeat a character a defined number of times. If cell A1 contained 65, the following formula [...]
Organisation Chart Built-in feature By Neale Blackwood Ever needed to create an Organisation Chart but don't have Visio? Have a look at Excel's built-in Org Chart creator. Click Insert menu > Diagrams and select the Org Chart. Use the drop downs on the toolbar to add to the chart. The AutoFormat button has a [...]
Create a Flow Chart Built-in feature By Neale Blackwood, 30 Apr 15 Do you need to draw a Flow Chart or document a process? In Excel 2003 and earlier versions, right click the toolbar and select the Drawing Toolbar. In the toolbar there is an AutoShapes button. Click that to see a list of [...]
Data Point Label Labelling a single data point By Neale Blackwood Did you know that you can label a single data point on a Line chart? This may be the highest, lowest or last data point on the line. You may want to label it to highlight a specific issue. To get a label [...]
How to Create Interactive Infographics By Jeff Robson (requires Excel 2010+) Normally InfoGraphics are just static PDFs ... but wouldn't it be great if they were a bit more useful and you could change them to see the specific things you're interested in? This example lets you choose a Country, then [...]
4 Tips to Chart like a Pro Make your Charts Zing! By Jeff Robson Charts are a great way to communicate information in a way that is easy for people to digest and understand. Here are four tips to help you make charts that zing! Label a single point on a graph You might [...]
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Pay my invoice
