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.
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 237"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]1-Aug [/TD]
[TD]Girlfriends Day[/TD]
[/TR]
[TR]
[TD="align: right"]2-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4-Aug[/TD]
[TD] Sister Day[/TD]
[/TR]
[TR]
[TD="align: right"]5-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7-Aug[/TD]
[TD] Lighthouse Day[/TD]
[/TR]
[TR]
[TD="align: right"]8-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]13-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]15-Aug[/TD]
[TD] Relaxation Day[/TD]
[/TR]
[TR]
[TD="align: right"]16-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17-Aug [/TD]
[TD]Black Cat Appreciation Day[/TD]
[/TR]
[TR]
[TD="align: right"]18-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]21-Aug[/TD]
[TD] Senior Citizen Day[/TD]
[/TR]
[TR]
[TD="align: right"]22-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]23-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]24-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]26-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]27-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]28-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]29-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]30-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]31-Aug[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 237"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]1-Aug [/TD]
[TD]Girlfriends Day[/TD]
[/TR]
[TR]
[TD="align: right"]2-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4-Aug[/TD]
[TD] Sister Day[/TD]
[/TR]
[TR]
[TD="align: right"]5-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7-Aug[/TD]
[TD] Lighthouse Day[/TD]
[/TR]
[TR]
[TD="align: right"]8-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]13-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]15-Aug[/TD]
[TD] Relaxation Day[/TD]
[/TR]
[TR]
[TD="align: right"]16-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17-Aug [/TD]
[TD]Black Cat Appreciation Day[/TD]
[/TR]
[TR]
[TD="align: right"]18-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]21-Aug[/TD]
[TD] Senior Citizen Day[/TD]
[/TR]
[TR]
[TD="align: right"]22-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]23-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]24-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]26-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]27-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]28-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]29-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]30-Aug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]31-Aug[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.