How do I change the color in a graph?

S

Samandruby

I want to highlight two columns (out of about 15) by making them a different
color than the other 13 columns. I have done everything and nothing seems to
work. Any ideas??
 
A

Andy Pope

Hi,

To manually change the colour select the columns and then click the
specific column you want to format. Once the single column is selected
bring up the format dialog by either double clicking it or pressing
CTRL+1. On the pattern tab change the area colour. Repeat procress for
the other column.

If the columns to be coloured vary with the data the have a look at
Jon's explanation of how to make conditional charts.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracked changes by multiple people modified to one 0
How do I convert shading to highlighting for specific colors 8
Select text of a particular shading color (VBA macro) 5
Dealing with a Pivot Table (when I don't want to) 0
Graph usage for times of day 0
Need Help with a VBA subroutine 0
Line graph colors 5
Color Changing Issues-same document 0

Top