Problem adding a vertical line to a graph with months on x-axis

  • Thread starter Thread starter zoutornian
  • Start date Start date
What isn't working?

Is your X axis a time-scale axis? You need to use the corresponding date as
the X values of the XY series that controls the vertical line. In the
time-scale axis, is your Base Unit days? Then you can use the date you want
as the XY series' X value. Is the Base Unit months? Then you need to use the
number of months since January 1900. If it were my chart, I'd use days as my
Base Unit, and the date for the XY series, because it's easier.

Is your X axis a category axis, using the months as labels, not as numerical
dates? Then count categories from the X axis minimum, and use that as your X
value for the XY series.

- Jon
 
It worked! Thank you for your help, Jon.

I'd prefer months on the X-axis because the data is recorded on a
monthly basis. I use the first day of each month to represent that
month because Excel doesn't (to my knowledge) have a data type for
months.

Is there some neat trick for displaying percentages on the secondary Y-
axis, in addition to the absolute values on the primary axis? The
difficulty is that the secondary Y-axis is already in use for the
vertical line.
 
Back
Top