Combination Stacked Bar Graph and Line Chart

L

LONeill13

Board Regular
Joined
Feb 12, 2013
Messages
135
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:
[TABLE="width: 240"]
<COLGROUP><COL style="WIDTH: 48pt" span=5 width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent, colspan: 2"]Business Unit[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Day[/TD]
[TD="bgcolor: transparent"]Period[/TD]
[TD="class: xl63, bgcolor: transparent"]BH[/TD]
[TD="class: xl63, bgcolor: transparent"]MF[/TD]
[TD="class: xl63, bgcolor: transparent"]SP[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent"]Curr Mth[/TD]
[TD="bgcolor: transparent, align: right"]294471.3[/TD]
[TD="bgcolor: transparent, align: right"]368146.8[/TD]
[TD="bgcolor: transparent, align: right"]750350.9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"]Curr Mth[/TD]
[TD="bgcolor: transparent, align: right"]131379.7[/TD]
[TD="bgcolor: transparent, align: right"]358319.9[/TD]
[TD="bgcolor: transparent, align: right"]420382.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"]Curr Mth[/TD]
[TD="bgcolor: transparent, align: right"]224038.2[/TD]
[TD="bgcolor: transparent, align: right"]79098.84[/TD]
[TD="bgcolor: transparent, align: right"]524356.8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"]Curr Mth[/TD]
[TD="bgcolor: transparent, align: right"]250396.1[/TD]
[TD="bgcolor: transparent, align: right"]267489.4[/TD]
[TD="bgcolor: transparent, align: right"]626029.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent"]Curr Mth[/TD]
[TD="bgcolor: transparent, align: right"]248761.2[/TD]
[TD="bgcolor: transparent, align: right"]221278.1[/TD]
[TD="bgcolor: transparent, align: right"]545953.8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent"]Curr Mth[/TD]
[TD="bgcolor: transparent, align: right"]249313.4[/TD]
[TD="bgcolor: transparent, align: right"]436905.3[/TD]
[TD="bgcolor: transparent, align: right"]502239.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent"]Curr Mth[/TD]
[TD="bgcolor: transparent, align: right"]300970.1[/TD]
[TD="bgcolor: transparent, align: right"]204918[/TD]
[TD="bgcolor: transparent, align: right"]542533.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Day[/TD]
[TD="bgcolor: transparent"]Period[/TD]
[TD="bgcolor: transparent"]Total[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1076139[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]904051.2[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1007092[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]824817.1[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1150517[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1062593[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1146223[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1163917[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1123372[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1366751[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1277170[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1365538[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]13[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1358537[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]14[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]964051.1[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1417612[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]16[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1328104[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]17[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1624871[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]18[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]1009845[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]19[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]2029798[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]2024852[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]21[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]2368506[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]22[/TD]
[TD="bgcolor: transparent"]Last Year[/TD]
[TD="bgcolor: transparent, align: right"]4346434[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Sort by date Sort by votes
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).
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Gloss Colours in A Stacked Bar Chart
Replies
2
Views
95
SteveP29
S
O
  • Question Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
1K
OrangeJuice
O
franklin_m
  • Question Question
VBA Search row for instances of pattern in two adjacent cells
Replies
3
Views
425
franklin_m
franklin_m
N
  • Question Question
2-step Dynamic Ranges and Charts
Replies
0
Views
984
Nick Loughton
N
A
  • Question Question
Creating a Pie Chart of a segment of a stacked bar in a Grouped Bar Chart (the bar chart I made is attached)
Replies
0
Views
289
afrailer
A

Forum statistics

Threads
1,223,248
Messages
6,171,021
Members
452,374
Latest member
keccles

Share this page

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