Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series - one value
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.charting
|
|||
|
|||
Series - one value
If you change your chart type from line to scatter, you can add the qurterly
series with its own x values. If you want the line to be a step fuction, you will need two points for eac querter (one for the first day and one for the last). You might also be able to do the same with line charts with date category axis but I have not tried... Best wishes, Boris "Mike" wrote: 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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series - one value
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. |
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 | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel |