If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do pair different data series.
I have 10 sets of data paired (y1,y2) for each x data point.
y1 is a integer and y2 is a percentage. I have this pair of data across 10 x values (x1, x2, ...) so x1 has 10 sets of y data (y1,y2),(y3,y4)... What I'm trying to do is stack each (y1,y2) for each x value in a bar chart BUT also group all the (y1,y2),(y3,y4)... across all 10 x values. I also need two y-axis. One for the integer values and one for the percentage values So for the I can't figure it out. =( Thanks for anyhelp out there!!! =) |
#2
|
|||
|
|||
If you are using 'stacked' in the same way as XL does, then what you
want to do makes little sense to me. Of course, it might perfect sense to you since it is your problem. {grin} First, what does it logically mean to put a % bar atop a quantity metric? Second, if you must do so then the two have to be on the same axis. Otherwise there is no consistent basis for measuring the quantities represented by the bars. So, I will assume that what you want to do is put the quantity (y1) adjacent to the % (y2), leave a small gap and repeat for the next set of x values. Maybe, something along the lines Dual Axis Clustered Column Chart http://www.tushar-mehta.com/excel/ti...xis/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have 10 sets of data paired (y1,y2) for each x data point. y1 is a integer and y2 is a percentage. I have this pair of data across 10 x values (x1, x2, ...) so x1 has 10 sets of y data (y1,y2),(y3,y4)... What I'm trying to do is stack each (y1,y2) for each x value in a bar chart BUT also group all the (y1,y2),(y3,y4)... across all 10 x values. I also need two y-axis. One for the integer values and one for the percentage values So for the I can't figure it out. =( Thanks for anyhelp out there!!! =) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line Graph Data Recognition | Nat | Charts and Charting | 2 | April 30th, 2005 02:07 PM |
Help with data not getting plotted | Scott Ehrlich | Charts and Charting | 1 | January 23rd, 2005 05:15 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |