Combination Stacked Bar Graph and Line Chart

[LONeill13]

Hi:

I'm having problems creating a combination stacked bar graph and line graph. What I'm trying to do is Create a Stacked Bar graph for the first section of data (Business Unit). That will give me sales by day by business unit stacked. I then want to create a line that shows Last Year Total sales as shown in the second set of data. I have tried selecting the data in the Last Year Total Sales table and copying/pasting to the Chart, but I don't get the paste special options to add another axis that I'm supposed to. PLEASE HELP! I've done this before, but it was years ago....

THANK YOU IN ADVANCE!

My data is below:

		Business Unit
Day	Period	BH	MF	SP
1	Curr Mth	294471.3	368146.8	750350.9
2	Curr Mth	131379.7	358319.9	420382.3
3	Curr Mth	224038.2	79098.84	524356.8
4	Curr Mth	250396.1	267489.4	626029.4
5	Curr Mth	248761.2	221278.1	545953.8
6	Curr Mth	249313.4	436905.3	502239.1
7	Curr Mth	300970.1	204918	542533.3
Day	Period	Total
1	Last Year	1076139
2	Last Year	904051.2
3	Last Year	1007092
4	Last Year	824817.1
5	Last Year	1150517
6	Last Year	1062593
7	Last Year	1146223
8	Last Year	1163917
9	Last Year	1123372
10	Last Year	1366751
11	Last Year	1277170
12	Last Year	1365538
13	Last Year	1358537
14	Last Year	964051.1
15	Last Year	1417612
16	Last Year	1328104
17	Last Year	1624871
18	Last Year	1009845
19	Last Year	2029798
20	Last Year	2024852
21	Last Year	2368506
22	Last Year	4346434

<COLGROUP><COL style="WIDTH: 48pt" span=5 width=64><TBODY>
</TBODY>

 

[Jon Peltier]

You have to paste (special) the data to the chart before you can do anything to it. It first will be another set of bars pasted on top of the others. Then you can change its type to a line chart: right click on it, choose Change Series Chart Type. I don't think you need a second axis, you just need to plot the day numbers as the X values (skip the period).