Tbieri -
Make sure the series you add for the vertical line is an XY Scatter
chart. Then make sure it points to the right Xvalues: right click the
chart, choose Source Data, click on the Series tab, select this new
series in the list on the left, and select the appropriate range for its
X values.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
tbieri wrote:
> Hi,
>
> I have created a dynamic chart following Tushar Mehta's
> information (thanks for the great website). The chart I
> created uses dates along the X-axis, and has the primary
> and secondary y-axis in use. The dynamic portion uses two
> dropdowns; one to pick a date range and one to pick a
> location.
>
> I want to add a vertical line for an event marker that
> takes place on a specific date, depending on the location.
> Typically I would create a series using the same date and
> two different y-values and plot it.
>
> The problem is the Xvalues is named range for the X-axis
> and when I paste the new series, it always appears on the
> first date on the X-axis. Creating an additional column
> with the data is possible, but problematic since the data
> is dynamic (database query that changes weekly).
>
> Any suggestions?
> Regards
> Tbieri
Similar Threads
