Blogs from Wise Owl on Charts in Excel

Showing blogs 1-7 (out of 7)

Drop Lines in Excel Charts: Ah, that's what I needed!

Posted by Michael Allsop on 24 May 2013

Ever had the feeling that you're missing something obvious? This blog highlights one particular chart option that you may well have overlooked.

Tags:   Excel | Charts

Problem with using VBA to create chart labels

Posted by Andy Brown on 04 April 2013

If your chart has more than a thousand data labels, this blog explains why you may experience problems.

Tags:   Excel | Charts    |    Writing VBA | Other    |    VBA macros | Working with charts

Highlighting negative columns in Excel charts

Posted by Michael Allsop on 01 October 2012

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

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

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

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

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    |    Writing VBA | Other    |    VBA macros | Working with charts
This page has 0 threads Add post