Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / April 2007

Tip: Looking for answers? Try searching our database.

Bubble Chart question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Flanagan - 28 Apr 2007 17:45 GMT
Is it possible to create a bubble chart with two series that share the same
X and Y values.  For example:

X    Y    values1   values2
10   11    300        0
14   20    150        0
20     5        0     100
30   30        0       40

I obviously haven't had any success <grin>.  I can create a bubble graph
with the x y and value1.  But I can't figureout how to get values2  with the
same x and y.  I can create an entirely seperate x y and values2 and add as
a new series, but my data is not constructed that way and it would be a pain
to re-arrange.

Thanks for any suggestions

Bob
Barb Reinhardt - 28 Apr 2007 18:00 GMT
Go to your graph
Select Chart -> Source Data
Select the SERIES tab and enter another  with the X,Y and size values you
want.  

HTH,
Barb Reinhardt

> Is it possible to create a bubble chart with two series that share the same
> X and Y values.  For example:
[quoted text clipped - 14 lines]
>
> Bob
Bob Flanagan - 28 Apr 2007 23:02 GMT
Barb, many thanks.

Bob

> Go to your graph
> Select Chart -> Source Data
[quoted text clipped - 26 lines]
>>
>> Bob
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.