Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a vertical line in a spreadsheat?
I have created a diagram generated by a spreadsheet wich I daily update with
new data. In the diagram I can see the curves updating and replaces the previous line. (the lines are horizonal) But... I would like to have a vertical representing todays date so I with ease can see the most actual point. In other words: Can I create a Vertical (dynamic) line in a diagram with horizonal curves? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a vertical line in a spreadsheat?
What type of chart do you have?
XY? Line? Do you want it to automatically change or are you willing to do something to the chart each day? one way to do this which will work in many charts is to use the Y Error bar and just have a value on todays date "ano" wrote: I have created a diagram generated by a spreadsheet wich I daily update with new data. In the diagram I can see the curves updating and replaces the previous line. (the lines are horizonal) But... I would like to have a vertical representing todays date so I with ease can see the most actual point. In other words: Can I create a Vertical (dynamic) line in a diagram with horizonal curves? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a vertical line in a spreadsheat?
I have a large chart measuring a variable. I enter the daily value manualy
and uses the diagram to monitor the change over time, so I might spot the trend. Tomorrows figures allways equals todays untill changed (A5=A4). Example: In 7 days where today is day 4: 5-4-3-4-4-4-4. Until changed day 5-7 has same value as day 4. Thats why it can be hard to spot present day in the diagram. It is a line. I would like it to be automatic, but if not possible Ill do what it takes. I can't get this Y error bar to do it in the way I want it. But if there is no other way Ill guess Ill have to find a way to sovle it with that function. "bj" wrote: What type of chart do you have? XY? Line? Do you want it to automatically change or are you willing to do something to the chart each day? one way to do this which will work in many charts is to use the Y Error bar and just have a value on todays date "ano" wrote: I have created a diagram generated by a spreadsheet wich I daily update with new data. In the diagram I can see the curves updating and replaces the previous line. (the lines are horizonal) But... I would like to have a vertical representing todays date so I with ease can see the most actual point. In other words: Can I create a Vertical (dynamic) line in a diagram with horizonal curves? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
Vertical line isn't vertical! | Charts and Charting in Excel | |||
Vertical line in a histogram (vertical bar chart) | Excel Discussion (Misc queries) | |||
Vertical scroll bar jumps scrolls line 1 to line 2705? | Excel Worksheet Functions | |||
How to add a vertical line to a Line Chart that aleady has 2 Y axi | Charts and Charting in Excel |