Data Table in Clustered Column Charts

=?Utf-8?B?TVE=?=

Guest

Posts: n/a

14th Mar 2006

I have created a pivot table with these data:

Count of User Year
Unit 2006 Grand Total
A 10 10
B 8 8
C 7 7
Grand Total 25 25

After that I created a Clustered Column Chart, and I am able to create a
data table with the values as shown from the table.

I would like to include another set of data as follow:

Unit percentage
A 1.27%
B 10.39%
C 70.00%

Is there any way that I can include these data (which is in the same excel
screen) in the same graph?

« template for comparing projected vs actual milestone completion? | Trying to change ColorIndex for series settings »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine Clustered Column Bar charts and Stacked column bar charts	=?Utf-8?B?UmljaGFyZA==?=	Microsoft Excel Charting	1	26th Oct 2006 02:44 AM
clustered stack column charts	=?Utf-8?B?TG91IFQ=?=	Microsoft Excel Charting	3	3rd Oct 2005 11:17 PM
Re: How to combine Clustered Column and Stacked Column charts in excel	Tushar Mehta	Microsoft Excel Charting	0	22nd Sep 2004 10:13 PM
How to combine Clustered Column and Stacked Column charts in excel	=?Utf-8?B?UmFtdSBSYXlhcHVkaQ==?=	Microsoft Excel Charting	0	22nd Sep 2004 09:17 PM
Re: stacked and clustered column charts	Jon Peltier	Microsoft Excel Charting	0	20th Aug 2004 11:58 PM