Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current day on a chart
I made a chart with days of the year, projected dates for things and actual
dates that they happened. I was wondering if i could put a "running line" that would move along the chart as the year went on. It would help show why the end of the chart doesn't look good. Possible? If it is, Could i also get something that fills in the column of dates as time does on? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current day on a chart
Hi Robert:
I figure from what you describe you need a so-called dynamic name range. This simply leaves out the future "zero's" so you don't need a running "vertical line" as you suggest by your last sentence.... See for instance Jon Peltier's website http://www.peltiertech.com/Excel/Cha...hartLinks.html for a number of helpful websites how to do this. If the dates have a consistent difference (e.g. days, or week numbers without interruptions) you can drag the range down and Excel is smart enough to fill it out correctly (e.g. showing Feb 1 and not Jan 32). Go the right under corner of the selected range (selecting two dates at least) and drag the black square downwards while keeping yr left mouse button pressed as far as you want; releasing the mouse button triggers the fill. Or you can just make a formula =[previous cell]+1 and excel displays the next day. Just trial a bit. HTH, Henk "Robert Brown" wrote: I made a chart with days of the year, projected dates for things and actual dates that they happened. I was wondering if i could put a "running line" that would move along the chart as the year went on. It would help show why the end of the chart doesn't look good. Possible? If it is, Could i also get something that fills in the column of dates as time does on? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current day on a chart
For some reason When I do it like you page says to it but when I put it on my
chart it doesn't go to the current date. It looks to me because I have a certain amount of data for my Category(X) values that when I only but the two values in for the vertical line it one goes over in the chart two data points. What am I doing wrong? Currently I have a list of all the dates and NA() for all the dates but the current date, but it would be nice to delete all of that and just have 4 cells for the current date. "Kelly O'Day" wrote: Robert: If I understand your question, you would like to be able to add a vertical line that shows the current date. Is this what you want? If it is, I have a how to page on adding a vertical line to a chart with just 4 cells. You could use the current date for setting the x values by formula and have the Y values go from 0 to your max Y value. If this sounds like it is of interest, here's the link: http://processtrends.com/pg_charts_vertical_line.htm "HEK" wrote in message ... Hi Robert: I figure from what you describe you need a so-called dynamic name range. This simply leaves out the future "zero's" so you don't need a running "vertical line" as you suggest by your last sentence.... See for instance Jon Peltier's website http://www.peltiertech.com/Excel/Cha...hartLinks.html for a number of helpful websites how to do this. If the dates have a consistent difference (e.g. days, or week numbers without interruptions) you can drag the range down and Excel is smart enough to fill it out correctly (e.g. showing Feb 1 and not Jan 32). Go the right under corner of the selected range (selecting two dates at least) and drag the black square downwards while keeping yr left mouse button pressed as far as you want; releasing the mouse button triggers the fill. Or you can just make a formula =[previous cell]+1 and excel displays the next day. Just trial a bit. HTH, Henk "Robert Brown" wrote: I made a chart with days of the year, projected dates for things and actual dates that they happened. I was wondering if i could put a "running line" that would move along the chart as the year went on. It would help show why the end of the chart doesn't look good. Possible? If it is, Could i also get something that fills in the column of dates as time does on? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current day on a chart
You need to use an XY (Scatter chart) for my technique to work.
Change your chart type to XY and see if it works. "Robert Brown" wrote in message ... For some reason When I do it like you page says to it but when I put it on my chart it doesn't go to the current date. It looks to me because I have a certain amount of data for my Category(X) values that when I only but the two values in for the vertical line it one goes over in the chart two data points. What am I doing wrong? Currently I have a list of all the dates and NA() for all the dates but the current date, but it would be nice to delete all of that and just have 4 cells for the current date. "Kelly O'Day" wrote: Robert: If I understand your question, you would like to be able to add a vertical line that shows the current date. Is this what you want? If it is, I have a how to page on adding a vertical line to a chart with just 4 cells. You could use the current date for setting the x values by formula and have the Y values go from 0 to your max Y value. If this sounds like it is of interest, here's the link: http://processtrends.com/pg_charts_vertical_line.htm "HEK" wrote in message ... Hi Robert: I figure from what you describe you need a so-called dynamic name range. This simply leaves out the future "zero's" so you don't need a running "vertical line" as you suggest by your last sentence.... See for instance Jon Peltier's website http://www.peltiertech.com/Excel/Cha...hartLinks.html for a number of helpful websites how to do this. If the dates have a consistent difference (e.g. days, or week numbers without interruptions) you can drag the range down and Excel is smart enough to fill it out correctly (e.g. showing Feb 1 and not Jan 32). Go the right under corner of the selected range (selecting two dates at least) and drag the black square downwards while keeping yr left mouse button pressed as far as you want; releasing the mouse button triggers the fill. Or you can just make a formula =[previous cell]+1 and excel displays the next day. Just trial a bit. HTH, Henk "Robert Brown" wrote: I made a chart with days of the year, projected dates for things and actual dates that they happened. I was wondering if i could put a "running line" that would move along the chart as the year went on. It would help show why the end of the chart doesn't look good. Possible? If it is, Could i also get something that fills in the column of dates as time does on? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current day on a chart
This would be the one thing that i did not have, Thank you!
"Kelly O'Day" wrote: You need to use an XY (Scatter chart) for my technique to work. Change your chart type to XY and see if it works. "Robert Brown" wrote in message ... For some reason When I do it like you page says to it but when I put it on my chart it doesn't go to the current date. It looks to me because I have a certain amount of data for my Category(X) values that when I only but the two values in for the vertical line it one goes over in the chart two data points. What am I doing wrong? Currently I have a list of all the dates and NA() for all the dates but the current date, but it would be nice to delete all of that and just have 4 cells for the current date. "Kelly O'Day" wrote: Robert: If I understand your question, you would like to be able to add a vertical line that shows the current date. Is this what you want? If it is, I have a how to page on adding a vertical line to a chart with just 4 cells. You could use the current date for setting the x values by formula and have the Y values go from 0 to your max Y value. If this sounds like it is of interest, here's the link: http://processtrends.com/pg_charts_vertical_line.htm "HEK" wrote in message ... Hi Robert: I figure from what you describe you need a so-called dynamic name range. This simply leaves out the future "zero's" so you don't need a running "vertical line" as you suggest by your last sentence.... See for instance Jon Peltier's website http://www.peltiertech.com/Excel/Cha...hartLinks.html for a number of helpful websites how to do this. If the dates have a consistent difference (e.g. days, or week numbers without interruptions) you can drag the range down and Excel is smart enough to fill it out correctly (e.g. showing Feb 1 and not Jan 32). Go the right under corner of the selected range (selecting two dates at least) and drag the black square downwards while keeping yr left mouse button pressed as far as you want; releasing the mouse button triggers the fill. Or you can just make a formula =[previous cell]+1 and excel displays the next day. Just trial a bit. HTH, Henk "Robert Brown" wrote: I made a chart with days of the year, projected dates for things and actual dates that they happened. I was wondering if i could put a "running line" that would move along the chart as the year went on. It would help show why the end of the chart doesn't look good. Possible? If it is, Could i also get something that fills in the column of dates as time does on? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Property Confusion | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel |