![]() |
Dates posted within a standard column chart
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! |
Dates posted within a standard column chart
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! |
All times are GMT +1. The time now is 10:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com