Put a point on a bar chart with a constant y and an x-value from a cell

**jraward** · 02-10-2011, 11:52 AM

any ideas? I have a bar chart that has a range of dates over a year and I have another chart that dynamically updates to show a magnified week according to the date in a cell. I want the big chart to have a dot on it to show the range or start date of the magnified version.
help!

**Andy Pope** · 02-10-2011, 12:23 PM

If the bar is really a bar chart then you can use a xy-scatter series.
If it's actually a column chart then a Line series could be used.

**jraward** · 02-11-2011, 06:19 AM

Originally Posted by Andy Pope

If the bar is really a bar chart then you can use a xy-scatter series.
If it's actually a column chart then a Line series could be used.

Excellent, thank you, I was trying to add it as a line chart using existing date values, with a scatter I was able to use specific ones. Thanks again.