Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

Charts in Excel blogs

Problem with using VBA to create chart labels

Posted by Andy Brown on 04 April 2013 | no comments
If your chart has more than a thousand data labels, this blog explains why you may experience problems.
Tags:   Excel / Charts   |   VBA macros / Excel Visual Basic

Highlighting negative columns in Excel charts

Posted by Michael Allsop on 01 October 2012 | no comments
Ever wondered if you can make negative columns automatically turn red in an Excel chart? Well now you can in Excel 2010!
Tags:   Excel / Charts

10 Excel Quick Tips

Posted by Andrew Gould on 02 December 2011 | no comments
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
Tags:   Excel / Formulae   |   Excel / Excel functions   |   Excel / Charts

How to Create Custom Charts in Microsoft Excel

Posted by Andrew Gould on 10 November 2011 | 1 comment
One of the most time-consuming things when creating charts in Excel is having to format them. This blog shows you how to save and reuse custom charts to ensure that you'll never have to format a chart again!
Tags:   Excel / Charts

Setting the Default Chart Type in Microsoft Excel

Posted by Andrew Gould on 10 November 2011 | no comments
When you create a chart, by default Excel always tries to give you a boring old column chart. If you primarily create pie charts it can be really annoying having to change the chart type every time you create one. This blog shows you how to set Excel to always create the type of chart that you want.
Tags:   Excel / Charts

Adding data labels to a chart using VBA

Posted by Andrew Gould on 08 June 2011 | 7 comments
Adding basic data labels to a chart can be done without using any programming code. This blog, however, shows you how to fine-tune Excel chart labels using VBA (Visual Basic for Applications) macros.
Tags:   Excel / Charts   |   Excel / Excel Visual Basic   |   VBA macros / Excel Visual Basic

All content copyright Wise Owl Business Solutions Ltd 2013. All rights reserved.