Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Marker based on Scenario
I run 30 quarterly reports and graph 3-5 measures on one chart. Each measure
includes five column charts: four for the quarterly results, and a fifth bar chart for the benchmark (formatted to overlap the quarterly results 100% it forms a box around them). Finally, a line chart containing ONLY markers for the YTD results. I would like the marker or at least the color of the marker to change when the YTD result that is represents is less than the benchmark it is being measured against. Anyone have any suggestions on how to accomplish this? Thanks in advance. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Marker based on Scenario
John -
See my conditional charting page: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "John" wrote in message ... I run 30 quarterly reports and graph 3-5 measures on one chart. Each measure includes five column charts: four for the quarterly results, and a fifth bar chart for the benchmark (formatted to overlap the quarterly results 100% it forms a box around them). Finally, a line chart containing ONLY markers for the YTD results. I would like the marker or at least the color of the marker to change when the YTD result that is represents is less than the benchmark it is being measured against. Anyone have any suggestions on how to accomplish this? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing chart color based on number entered | Charts and Charting in Excel | |||
Changing the color of a list entry based on a tolerance | Excel Worksheet Functions | |||
Changing display of decimal value based on the value in the cell | Excel Worksheet Functions | |||
Sub-Totalling Based upon a changing field | Excel Worksheet Functions | |||
changing value of a cell based on another cell color | Excel Discussion (Misc queries) |