Conditional chart formating

M

Mark

I need to format my charts so the color of the data points change depending
on the value amount. My tabels are already set up and cannot be change or
have anything new added due to the amount and delicacy of data. Is there a
macro I can use. Perhaps a formula I can put somewhere?
 
A

Andy Pope

Hi,

Ed Ferrero has a vba example. It's for a column chart but the code will
be very similar. Instead of interior fill you will be doing marker stuff.
eg:
.MarkerBackgroundColorIndex = 50
.MarkerForegroundColorIndex = 50

Conditional Chart Formatting example.
http://www.edferrero.com/charting.aspx

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

Creating a Chart on form from selected data in query. 0
Mail Merge - displaying a conditional number of decimals 5
Drop down list control value in vba 2
Odd Chart Format Results 1
Conditional Formatting of Bar Charts 2
Conditionally Format Data Points in Line Chart 0
Consolidation Table from Different Excel Tabs with Different Format 1
Conditional Formatting question.... 1

Top