Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel graphs - two data sets on the same y-axis?
Hi,
I'm trying to display two sets of data, with identical X-axis on the same Y-axis, but am finding it hard. I don't want 4 bars for each X value, but a graph with 4 X-catergories containing 2 bars each, then an identical x-axis with a further similar data set (i.e. 4 x 2 bars) - anyone have a clue how to do this? I've tried just making two graphs and deleting the Y-axis from one, but the X-axis never line up in something like Powerpoint when I put them together! Thanks! |
#2
|
|||
|
|||
Forgot to say, this is for Excel 2000 bar graphs.
"AndyB" wrote: Hi, I'm trying to display two sets of data, with identical X-axis on the same Y-axis, but am finding it hard. I don't want 4 bars for each X value, but a graph with 4 X-catergories containing 2 bars each, then an identical x-axis with a further similar data set (i.e. 4 x 2 bars) - anyone have a clue how to do this? I've tried just making two graphs and deleting the Y-axis from one, but the X-axis never line up in something like Powerpoint when I put them together! Thanks! |
#3
|
|||
|
|||
Maybe Jon Peltier's Stacked Charts instructions will help you:
http://www.peltiertech.com/Excel/Cha...kedCharts.html AndyB wrote: Hi, I'm trying to display two sets of data, with identical X-axis on the same Y-axis, but am finding it hard. I don't want 4 bars for each X value, but a graph with 4 X-catergories containing 2 bars each, then an identical x-axis with a further similar data set (i.e. 4 x 2 bars) - anyone have a clue how to do this? I've tried just making two graphs and deleting the Y-axis from one, but the X-axis never line up in something like Powerpoint when I put them together! Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How can I look up data in a different workbook in an excel spread. | Excel Worksheet Functions | |||
Moving blocks of data in excel | Excel Discussion (Misc queries) | |||
Excel should let me align data labels in different series (Excel . | Charts and Charting in Excel | |||
Layout/Formatting problems of Data Queries in Excel? | Excel Discussion (Misc queries) |