ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Dates posted within a standard column chart (https://www.excelbanter.com/charts-charting-excel/208428-dates-posted-within-standard-column-chart.html)

Folletti

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!

ShaneDevenshire

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