Vertical line between two dates (97)

Topic

New Reply

No, just add your line as data values like your other series. Then, right-click the column or other object that you’re creating, hit Chart-type and change the chart type on this series to line.

Reply | Quote

Replies

My question is similar to the question in post number 72609 where the poster wanted a vertical line on today’s date. I have a chart with dates for monday to friday each week; we made a change on a particular saturday. I’d like a vertical line on that saturday to indicate where we expect to see a difference in the chart figures.

When I insert a vertical line using the drawing toolbar, it moves each time I add a new day. I also have a comment pointing to the vertical bar, and it moves as well.

I’m pretty much a beginner and did not understand the explanation in the other post about a new series and scatter chart. I’m using a line chart. I tried adding min and max values to rows that show the saturday date and pasting those cells using paste special, but I just got a two column blank space on the chart.

I’m hoping that since my bar should stay on the same date, my solution might be easier. I don’t care if I use the drawing toolbar or some calculated line. I hope someone can tell me how to get the vertical line and comment to stay put on the specific date. Thanks.

Reply | Quote

Well I got it to work by doing a new data sheet and then the chart. I entered all the dates, then just the min and max values for Sept 7. Then I did the chart. The line was just where it belonged. The values were exactly the same as in the original chart where I had added that series last. Then I copied the rest of the values. Now it looks fine.

I don’t know what I’ve learned from this. Is it a bug or can you not expect to enter a new series to an existing chart and expect it to show up in the right place if the series doesn’t begin at the first x axis value?

Reply | Quote

I still don’t get it, but I had another puzzle yesterday, and this seems to have the same problem. I did get an almost vertical line on the first date on the chart. I’m hoping for a very vertical line on a particular date further on in the chart.

Here’s what I did, so you can tell how lost I am. I added a row to the data for the sep 8 saturday, and on that row entered in two previously unused columns the bottom and top values on my scale. I highlighted the two new cells, did CTRL+C to copy them, went to the chart sheet, did a paste special, selected new series and categories. After that gave me the almost vertical line on the first date on the chart, I deleted that, went into format series, did an Add, selected the new cells as the data values. The results were the same.

The cells are on a row with the Sept 8 date in column A, which is within the range of the Category X axis labels. The almost vertical line shows a date of August 14.

This happened to me yesterday when I tried to have one line for the dates from August 14 to Sept 7 and another line starting at Sept 10 to the present. The data values show correctly when I check them in Format Series, but both lines started at August 14. The second one had the values for the cells starting on Sept 10, but the date points showed August 14 , 15 etc.

Maybe what I didn’t understand yesterday is what I don’t understand about my vertical line today. I suspect that it would help to understand what the word series means what makes lines part of an existing series or not.

Also, it would be nice if it really were vertical, but that’s minor.

Reply | Quote

Ok, I got a vertical line (well bar) by changing the chart type for the series for the one date (Sep 8) to a bar chart. But it’s still showing as Aug 14. There’s now a gap in the other series lines between sep 7 and sep 10. I wish someone could explain what I don’t understand here.

Reply | Quote