Dates posted within a standard column chart

F

Folletti

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!
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top