Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting with Benchmarks
I have to create several charts that will identify two things - a 5yr
trendline showing their percentages on certain criterial and secondly where they lie against certain benchmarks for the same periode. The benchmarks cannot be stacked columns but dashes or some type of mark. See data below. 2004 2005 2006 2007 ABC 65% 66% 67% 68% DEF 66% 65% 64% 68% Benchmarks 20% 65% 67% 67% 70% 50% 66% 68% 68% 70% 75% 70% 71% 72% 73% Ideally, I would have a trend for the 4 years for the 4 companies and would have a dash or line in a vertical way for the benchmarks for each year so I'm combining a horizontal line with a vertical disjoined stacked bar, possibly? This would show where they are against benchmarks placed on them for that period. Help!!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting with Benchmarks
http://peltiertech.com/Excel/Charts/...HorizLine.html
http://peltiertech.com/WordPress/exa...-with-targets/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Penny" wrote in message ... I have to create several charts that will identify two things - a 5yr trendline showing their percentages on certain criterial and secondly where they lie against certain benchmarks for the same periode. The benchmarks cannot be stacked columns but dashes or some type of mark. See data below. 2004 2005 2006 2007 ABC 65% 66% 67% 68% DEF 66% 65% 64% 68% Benchmarks 20% 65% 67% 67% 70% 50% 66% 68% 68% 70% 75% 70% 71% 72% 73% Ideally, I would have a trend for the 4 years for the 4 companies and would have a dash or line in a vertical way for the benchmarks for each year so I'm combining a horizontal line with a vertical disjoined stacked bar, possibly? This would show where they are against benchmarks placed on them for that period. Help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charting | Charts and Charting in Excel | |||
charting in VBE | Charts and Charting in Excel | |||
charting in vb.net | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
3d charting | Charts and Charting in Excel |