This tutorial describes how to make step charts via Excel line charts:
http://peltiertech.com/WordPress/lin...vs-step-chart/
If you want to show the horizontal segments only:
http://peltiertech.com/WordPress/200...ithout-risers/
You can also do it with XY series and error bars:
http://peltiertech.com/Excel/ChartsHowTo/StepChart.html
You can even do it without duplicating the range, as shown in the previous
link, but it's trickier and in some cases, Excel reverts back to the regular
range.
- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______
"Mike" wrote in message
...
Hi. I have a line chart with a series of percentages in N14 through N65.
There is one point for each week of 52 weeks of the year.
In cell N7 I have the running average for Q1.
In cell N8 I have the running average for Q2.
In Cell N9 I have the running average for Q3.
In Cell N10 I have the running avergage for Q4.
I would like to chart another line that shows the quarterly average. 13
values of N7, followed by 13 values of N8; then N9, then N10.
Is there a way to do this other than adding another column that contains
these values?
Thanks,
Mike.