Home |
Search |
Today's Posts |
|
#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!!! =) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Series fill of "patchy" Data set or some Programming fix | Excel Worksheet Functions | |||
Setting Series data in VBA | Charts and Charting in Excel | |||
HELP- Copy a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
Format Data Series Markers | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |