| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Coloring the scales of a chart
I would like to make a line graph that is colored between the horozontal
lines I specify i.e. 1.344 Green Area Between .525 and 1.343 Yellow Between -.290 and .525 Pink < -.300 Red If the plot point is .750 it would be in the Yellow area All points will fall between these brackets. How do I color the areas of the chart? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Coloring the scales of a chart
Hi,
Have a look at Jon's page on color banding http://peltiertech.com/Excel/Charts/...tml#HorizBands Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Paul H" wrote in message ... I would like to make a line graph that is colored between the horozontal lines I specify i.e. 1.344 Green Area Between .525 and 1.343 Yellow Between -.290 and .525 Pink < -.300 Red If the plot point is .750 it would be in the Yellow area All points will fall between these brackets. How do I color the areas of the chart? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Coloring the scales of a chart
"Paul H" wrote: I would like to make a line graph that is colored between the horozontal lines I specify i.e. 1.344 Green Area Between .525 and 1.343 Yellow Between -.290 and .525 Pink < -.300 Red If the plot point is .750 it would be in the Yellow area All points will fall between these brackets. How do I color the areas of the chart? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 scales in 1 chart | Charts and Charting in Excel | |||
| Coloring of Excel Chart | Charts and Charting in Excel | |||
| Chart Coloring | Charts and Charting in Excel | |||
| xy chart -- x and y axes scales min and max | Charts and Charting in Excel | |||
| Dynamic pie chart coloring | Excel Discussion (Misc queries) | |||
Hybrid Mode
