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.
1-Aug Girlfriends Day
2-Aug
3-Aug
4-Aug Sister Day
5-Aug
6-Aug
7-Aug Lighthouse Day
8-Aug
9-Aug
10-Aug
11-Aug
12-Aug
13-Aug
14-Aug
15-Aug Relaxation Day
16-Aug
17-Aug Black Cat Appreciation Day
18-Aug
19-Aug
20-Aug
21-Aug Senior Citizen Day
22-Aug
23-Aug
24-Aug
25-Aug
26-Aug
27-Aug
28-Aug
29-Aug
30-Aug
31-Aug

<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.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

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