Dynamic Chart and then some

[tbieri]

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

 

[Jon Peltier]

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/
_______