Hello again,
I just joined this forum and everyone has been extremely helpful! I am back with another question. I am trying to create a 3-axis graph, combining a stacked column graph with a line graph above. As for the column graph, the X-Axis is labeled "Year" with 2010-2013. The stacked bar graph represents the number of transactions that took place in each county for a given year (Counties stacked on top of one another, each represented by a different color.) The Y-Axis label is currently "number of transactions". I would like to plot total sales volume above the stacked column graph as a line. There will be one line for each county, each data point representing the total sales volume for that county in a given year. I would like to make the other Y-Axis label "sales volume". Does this make sense? I am having trouble uploading examples.
Below is the table I have used to create the stacked column graph, which works perfectly. I just can't figure out where to add the sales volume figures for each county to get it to plot above in a line.
County 2013 2012 2011 2010
Los Angeles 4 14 15 11
Orange 0 3 0 6
Riverside 1 0 0 0
San Bernardino 0 3 0 0
San Diego 0 3 1 0
Ventura 0 0 2 1
Totals 5 23 18 18
Below is the table I am using to create the line graph, this also works perfect. Any help would be much appreciated!
County 2013 2012 2011 2010
Los Angeles $314,550,000 $787,005,909 $932,985,440 $653,238,960
Orange $0 $139,900,000 $0 $375,600,000
San Bernardino $0 $213,475,000 $0 $0
San Diego $0 $253,850,000 $80,400,000 $0
Riverside $58,000,000 $0 $0 $0
Ventura $0 $0 $130,100,000 $81,500,000
Bookmarks