Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 19th 13, 03:26 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 90
Default column charts with set set of data

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   Report Post  
Old June 19th 13, 06:45 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,727
Default column charts with set set of data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
column charts with multiple data sets Dave Shultz Charts and Charting in Excel 1 October 22nd 08 01:09 AM
Combine Clustered Column Bar charts and Stacked column bar charts Richard Charts and Charting in Excel 1 October 26th 06 02:44 AM
Creating charts - first row&column treated as normal data Enzo Charts and Charting in Excel 4 July 6th 06 09:28 PM
Data Table in Clustered Column Charts MQ Charts and Charting in Excel 0 March 14th 06 07:46 AM
Column charts with multiple data in each column steve root Charts and Charting in Excel 1 June 22nd 05 05:16 PM


All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017