I have a regular column chart with dates at the bottom, and the columns are
the # of cases made per week. I'm trying to include the dates the Case
specifications were changed within the chart. I only want to have a point
within the chart showing the date it was created within the dates already
showing. For example, I have the dates of 10/1, 10/6, 10/13, and 10/20 on
the X-axis. There are four columns per date. The dates of the specification
changes are 10/9, 10/14, and 10/15. I'd like points showing on those dates
with Version 1, Version 2, and Version 3 marked. Any ideas???

Thanks in advance!

Hi,

It's not clear where you want the point on the Y axis. But you can create a
second series with values that would put the points at the desired position
on the Y-axis. Plot this new series on the chart, shen select this series
and choose the Chart, Chart Type command and select Line. Now you should
have a line and a column chart being plotted. Select the line and format it
to not show the line - Line None on the Patterns tab of the Format Data
Series dialog box.

--
Thanks,
Shane Devenshire


"Folletti" wrote:

I have a regular column chart with dates at the bottom, and the columns are
the # of cases made per week. I'm trying to include the dates the Case
specifications were changed within the chart. I only want to have a point
within the chart showing the date it was created within the dates already
showing. For example, I have the dates of 10/1, 10/6, 10/13, and 10/20 on
the X-axis. There are four columns per date. The dates of the specification
changes are 10/9, 10/14, and 10/15. I'd like points showing on those dates
with Version 1, Version 2, and Version 3 marked. Any ideas???

Thanks in advance!