ScottInTexas
Board Regular
- Joined
- Oct 28, 2003
- Messages
- 178
I want to create a chart that has columns for days of interest (like a time line) I don't care what the Y value is, just so that the column goes to the top of the chart on a specific date. So the X values should be dates from 1/1 through 12/31. The Y value is just a marker that moves from left to right with each day at the middle of the Y values (like a scatter chart with 1 value). When I try to create the chart the first thing that happens is excel demands I select 2 series (for a combo chart). I have a column of Dates, a column of Dates of interest (the columns in the chart) and the names of the dates of interest (Relaxation day for example). So I want a column that is labeled Relaxation Day at the August 15th X and the moving marker would be intersecting with that column at some value Y. I set up the data in 365 Rows, each with column A being the date, Column B is the holiday. When I create the chart it automatically uses the row number rather than the date in column A. I changed the chart data and got the X axis to show the dates, but then the Y axis also shows dates. I just deleted the Y axis so it would quit bothering me. Here are the dates of interest for August.
<tbody>
</tbody>
That's two columns. Can someone get me started here? Once I get a grip on how to chart is I can add my automation in code.
Thanks for the help.
<colgroup><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>
That's two columns. Can someone get me started here? Once I get a grip on how to chart is I can add my automation in code.
Thanks for the help.