A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

I want to create 4 pie charts in a line



 
 
Thread Tools Display Modes
  #1  
Old July 5th, 2005, 12:04 AM
Shweta
external usenet poster
 
Posts: n/a
Default I want to create 4 pie charts in a line

I have to create 4 pie charts in a line with same legends but different data
series.
  #2  
Old July 5th, 2005, 08:32 AM
Andy Pope
external usenet poster
 
Posts: n/a
Default

Hi,

Create the 4 charts as chartobjects on a worksheet, only enable the
legend for one of the charts. If the charts must be on a chart sheet
then you can create a blank chartsheet by pressing F11 whilst in an
empty cell, make sure the surrounding cells are also empty. Then you can
change the Location of the chartobjects to be the new chartsheet rather
than the worksheet.

Cheers
Andy

Shweta wrote:
I have to create 4 pie charts in a line with same legends but different data
series.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I hide 0 values in line charts Stephan Charts and Charting 2 April 12th, 2005 12:55 PM
Can't create dynamic charts Brian Sells Charts and Charting 7 March 22nd, 2005 04:23 AM
How to force continuous lines in line charts Phillip Earthlink net> Charts and Charting 5 December 21st, 2004 10:43 PM
Dynamic Labels for Line Charts Smooth Charts and Charting 2 May 26th, 2004 04:09 AM
Best way to create a vertical line that moves when axis changes Jon Peltier Charts and Charting 1 February 3rd, 2004 12:46 PM


All times are GMT +1. The time now is 11:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.