| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do make a line correspond to date
I have a chart with horizontal bars and I want to put a vertical (trend) date
line that corresponds to today's date. -- DMM |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do make a line correspond to date
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I have a chart with horizontal bars and I want to put a vertical (trend) date line that corresponds to today's date. -- DMM |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do make a line correspond to date
Hi Jon,
I appreciate the input, but I may be doing somehting wrong because I keep getting another horizontal line. Below is a sample of what I'm trying to do. 92215------value---value----------------value 92364--value------------------------value------------value 78952------------------value--value--value------value 5/1 5/31 6/1 6/30 7/1 7/31 8/1 8/31 If you can imagine the Y axis is a text and the values whole numbers. The X axis are dates (formulated). When I try to run your program, I am getting a bar at the end of each line. I'm sure I'm doing one little thing wrong, but I can't find it. DMM "Jon Peltier" wrote: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I have a chart with horizontal bars and I want to put a vertical (trend) date line that corresponds to today's date. -- DMM |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do make a line correspond to date
The bar might just be the series being added. You need to select the bar, go
to Chart menu Chart Type, and change it to an XY type. The article should help with the rest of the procedure. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Hi Jon, I appreciate the input, but I may be doing somehting wrong because I keep getting another horizontal line. Below is a sample of what I'm trying to do. 92215------value---value----------------value 92364--value------------------------value------------value 78952------------------value--value--value------value 5/1 5/31 6/1 6/30 7/1 7/31 8/1 8/31 If you can imagine the Y axis is a text and the values whole numbers. The X axis are dates (formulated). When I try to run your program, I am getting a bar at the end of each line. I'm sure I'm doing one little thing wrong, but I can't find it. DMM "Jon Peltier" wrote: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I have a chart with horizontal bars and I want to put a vertical (trend) date line that corresponds to today's date. -- DMM |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do make a line correspond to date
Okay, I have the line, but now I am having trouble getting it straight by date.
-- DMM "Jon Peltier" wrote: The bar might just be the series being added. You need to select the bar, go to Chart menu Chart Type, and change it to an XY type. The article should help with the rest of the procedure. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Hi Jon, I appreciate the input, but I may be doing somehting wrong because I keep getting another horizontal line. Below is a sample of what I'm trying to do. 92215------value---value----------------value 92364--value------------------------value------------value 78952------------------value--value--value------value 5/1 5/31 6/1 6/30 7/1 7/31 8/1 8/31 If you can imagine the Y axis is a text and the values whole numbers. The X axis are dates (formulated). When I try to run your program, I am getting a bar at the end of each line. I'm sure I'm doing one little thing wrong, but I can't find it. DMM "Jon Peltier" wrote: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I have a chart with horizontal bars and I want to put a vertical (trend) date line that corresponds to today's date. -- DMM |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do make a line correspond to date
Did you change it to an XY type? Not a line type.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Okay, I have the line, but now I am having trouble getting it straight by date. -- DMM "Jon Peltier" wrote: The bar might just be the series being added. You need to select the bar, go to Chart menu Chart Type, and change it to an XY type. The article should help with the rest of the procedure. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Hi Jon, I appreciate the input, but I may be doing somehting wrong because I keep getting another horizontal line. Below is a sample of what I'm trying to do. 92215------value---value----------------value 92364--value------------------------value------------value 78952------------------value--value--value------value 5/1 5/31 6/1 6/30 7/1 7/31 8/1 8/31 If you can imagine the Y axis is a text and the values whole numbers. The X axis are dates (formulated). When I try to run your program, I am getting a bar at the end of each line. I'm sure I'm doing one little thing wrong, but I can't find it. DMM "Jon Peltier" wrote: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I have a chart with horizontal bars and I want to put a vertical (trend) date line that corresponds to today's date. -- DMM |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do make a line correspond to date
Yes, I did. I think the problem is with my data
05/24/06 0 05/24/06 0 05/24/06 0 I would like the line to move with today's date. I know it's some really stupid I'm doing. Thanks for all your help thus far. -- DMM "Jon Peltier" wrote: Did you change it to an XY type? Not a line type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Okay, I have the line, but now I am having trouble getting it straight by date. -- DMM "Jon Peltier" wrote: The bar might just be the series being added. You need to select the bar, go to Chart menu Chart Type, and change it to an XY type. The article should help with the rest of the procedure. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Hi Jon, I appreciate the input, but I may be doing somehting wrong because I keep getting another horizontal line. Below is a sample of what I'm trying to do. 92215------value---value----------------value 92364--value------------------------value------------value 78952------------------value--value--value------value 5/1 5/31 6/1 6/30 7/1 7/31 8/1 8/31 If you can imagine the Y axis is a text and the values whole numbers. The X axis are dates (formulated). When I try to run your program, I am getting a bar at the end of each line. I'm sure I'm doing one little thing wrong, but I can't find it. DMM "Jon Peltier" wrote: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I have a chart with horizontal bars and I want to put a vertical (trend) date line that corresponds to today's date. -- DMM |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do make a line correspond to date
Well, today is 05/24/07, so you may be off by 365 days :-)
You could simply put =TODAY() into the cells, and they'll update whenever you open the file. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Yes, I did. I think the problem is with my data 05/24/06 0 05/24/06 0 05/24/06 0 I would like the line to move with today's date. I know it's some really stupid I'm doing. Thanks for all your help thus far. -- DMM "Jon Peltier" wrote: Did you change it to an XY type? Not a line type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Okay, I have the line, but now I am having trouble getting it straight by date. -- DMM "Jon Peltier" wrote: The bar might just be the series being added. You need to select the bar, go to Chart menu Chart Type, and change it to an XY type. The article should help with the rest of the procedure. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Hi Jon, I appreciate the input, but I may be doing somehting wrong because I keep getting another horizontal line. Below is a sample of what I'm trying to do. 92215------value---value----------------value 92364--value------------------------value------------value 78952------------------value--value--value------value 5/1 5/31 6/1 6/30 7/1 7/31 8/1 8/31 If you can imagine the Y axis is a text and the values whole numbers. The X axis are dates (formulated). When I try to run your program, I am getting a bar at the end of each line. I'm sure I'm doing one little thing wrong, but I can't find it. DMM "Jon Peltier" wrote: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I have a chart with horizontal bars and I want to put a vertical (trend) date line that corresponds to today's date. -- DMM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell colors to correspond to different dates | Excel Worksheet Functions | |||
| Why doesn't the equation correspond to the graphic? | Excel Discussion (Misc queries) | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| find value in array on sep sheet & ret correspond val from col lef | Excel Discussion (Misc queries) | |||
| I need a form with 5 buttons that correspond with values 1-5 | Excel Discussion (Misc queries) | |||
Linear Mode
