Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line chart - Series designation
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line chart - Series designation
The chart has to get its values from somewhere. If you're adding a series of
13 points, you'll need a range that long with the data. You could use a different technique to add a line, which only requires one data point, by adding an XY series and giving it an error bar: http://peltiertech.com/Excel/Charts/...orzErrBar.html - 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
Show average line by series on a line chart | Charts and Charting in Excel | |||
Add line series to stacked bar chart | Charts and Charting in Excel | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
interrupted series in a line chart | Charts and Charting in Excel |