Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Floating Year-To-Date Line
Here's what I've got. I'm given a line graph charting dating on a weekly
basis over a full year. A goal line has been adding by putting the goal in a second column, but it's the same number just repeated 60 times. Also, I've been asked to put in a floating YTD line. Each week when the data is updated, the YTD value will change. I want to add a line to the chart that graphically shows this value, but it has to be a line that goes across the whole graph and is only done with one data point. Does any of this make sense? Can anyone tell me how to do this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Floating Year-To-Date Line
Hi,
You can do this just the same way you did the Goal line, create a new column of data where all the cells refer to the YTD calculation. To make both the Goal line and the YTD line "look" like they are just one entry, double-click the line and on the Patterns tab turn off the Marker option (None) -- cheers, Shane Devenshire "CorporateQAinTX" wrote: Here's what I've got. I'm given a line graph charting dating on a weekly basis over a full year. A goal line has been adding by putting the goal in a second column, but it's the same number just repeated 60 times. Also, I've been asked to put in a floating YTD line. Each week when the data is updated, the YTD value will change. I want to add a line to the chart that graphically shows this value, but it has to be a line that goes across the whole graph and is only done with one data point. Does any of this make sense? Can anyone tell me how to do this? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Floating Year-To-Date Line
I thought I could get away with only using one data point, but this will
work. Thanks a bunch. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Floating Year-To-Date Line
Hi,
Well there is a way to get away with this by using 2 data points (first and last points) but the method I suggested is pretty easy. -- Thanks, Shane Devenshire "CorporateQAinTX" wrote: I thought I could get away with only using one data point, but this will work. Thanks a bunch. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Floating Bars on Line-Bar Charts? | Charts and Charting in Excel | |||
How to Combine a Floating Column Chart with Line? | Charts and Charting in Excel | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
Formula for Calculating a Floating Date | Excel Worksheet Functions | |||
Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) |