Hi, I'm trying to add a vertical line to an area chart on an Access Report. In Excel I would have done this by adding a dummy series, but I can't figure out how to do this in Access. The data for the area chart looks like this:
date percent
01-jan-05 80%
01-mar-06 50%
01-may-08 20%
I then want to add a vertical line at a specific date, for example an x-y scatter chart type with the following data:
date percent
15-jun-06 0%
15-jun-06 100%
Any ideas would be great!
date percent
01-jan-05 80%
01-mar-06 50%
01-may-08 20%
I then want to add a vertical line at a specific date, for example an x-y scatter chart type with the following data:
date percent
15-jun-06 0%
15-jun-06 100%
Any ideas would be great!