Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I vary graph color by range value
I would like to create a chart where the color of the bar varies depending on
the point value. For example the range 0-1.99- red, 2.00 through 2.99 - yellow, and 2.99 through 5.00 - green. Any ideas? |
#2
|
|||
|
|||
The easiest way to do this is to have a data series for the RED range,
another for YELLOW and another for GREEN. You can then create a "stacked" column or bar chart. I'm assuming here that if you want a point in GREEN, you won't also want it in RED. "pcover" wrote: I would like to create a chart where the color of the bar varies depending on the point value. For example the range 0-1.99- red, 2.00 through 2.99 - yellow, and 2.99 through 5.00 - green. Any ideas? |
#3
|
|||
|
|||
The following link does two colors. Extending it to 3 should be pretty
straightforward. http://groups- beta.google.com/group/microsoft.public.excel.charting/browse_thread/thr ead/124801ec8fec8ba7/f72d941a0711c714?q=conditional+chart+group: *Excel*+author:tushar&rnum=24&hl=en#f72d941a0711c7 14 -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I would like to create a chart where the color of the bar varies depending on the point value. For example the range 0-1.99- red, 2.00 through 2.99 - yellow, and 2.99 through 5.00 - green. Any ideas? |
#4
|
|||
|
|||
Here's another conditional chart example:
http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ pcover wrote: I would like to create a chart where the color of the bar varies depending on the point value. For example the range 0-1.99- red, 2.00 through 2.99 - yellow, and 2.99 through 5.00 - green. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions |