I want the bar chart with customer selected colors, green color f.

J

junminliu

I want to create a bar chart with the following spec.

the first bar with green color

the 2nd bar with blue color

the 3rd and beyond with red color
 
T

Tushar Mehta

An option would be to set the color palette appropriately (Tools |
Options... | Color tab) and then for the chart set the 'vary color by
points' option. To access the last one double-click the plotted series
and in the resulting dialog box select the Options tab.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Bar Chart with Data Elements 1
Chart Formatting 1
how to change color gradients in a bar chart 0
Chart Bars 1
Plotting Line Graphs to Specific Bar Graphs 0
How to let pivot table chart's format stay after refreshing data. 2
conditional color fill of bar graphs 1
color of last bar on bar chart 4

Top