Create A Combo Chart

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.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
I think you need some data for the Y axis.
If I'm understanding you correctly, this could be as simple as a 1 for the dates of interest, and a 0 for every other date.
You could do this manually, or you could do it by a simple formula, such as
=if(isblank(b1),0,1)
Where b1 contains the text for dates of interest.
This will put a 1 next to them.
Then set your y axis min and max values to 0 and 1 respectively.
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,250
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top