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. |
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. |
All times are GMT +1. The time now is 08:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com