Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have data that looks similar to this...
Month Minutes % Loss March 151 9.2% April 196 12.7% May 188 12.9% June 142 8.30% I would like to display it in a column chart as follows Minutes would be displayed as a column that uses the primary axis. % Loss would also be displayed as a column and used the secondary axis. Both values for March would be displayed as columns,side by side, same for April, May, and June. When I try to do this the minutes and % losses are stacked on top of one another instead of side by side. is this doable? Thanks, Tonso |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi Tonso,
Am Tue, 18 Jun 2013 19:26:02 -0700 (PDT) schrieb Tonso: I have data that looks similar to this... Month Minutes % Loss March 151 9.2% April 196 12.7% May 188 12.9% June 142 8.30% I would like to display it in a column chart as follows Minutes would be displayed as a column that uses the primary axis. % Loss would also be displayed as a column and used the secondary axis. you have to choose grouped columns and not stacked columns. And that it will displayed side by side make between Minutes and %Loss a dummy column. Or have a look: https://skydrive.live.com/#cid=9378A...121822A3%21326 for workbook "Tonso" Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
column charts with multiple data sets | Charts and Charting in Excel | |||
Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
Creating charts - first row&column treated as normal data | Charts and Charting in Excel | |||
Data Table in Clustered Column Charts | Charts and Charting in Excel | |||
Column charts with multiple data in each column | Charts and Charting in Excel |