How do I set up excel chart that will change col. colors automatic

C

ChartWoman

I have charts that are maintained daily and the column colors depend on the
values.
These changes are manually maintained. I would like to have them changed
based on an if thenelse statement or a macro. I would welcome any
suggestions to resolve this issue.
 

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

Keeping chart colors but changing theme 8
how to change color gradients in a bar chart 0
Manual or Automatic Paragraph Spacing? 2
Paste Excel chart in Powerpoint - how to "send to back" the pasted chart 1
Excel 2007 Chart Colors 3
Charts created in 97-2004 color shifts when editing in 2008 11
Color change for Column Chart 4
Change gradient color in chart for Excel 2007 5

Top