 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / October 2006Bubble charts
A colleague of mine was asking me to use a bubble chart to show the following data for 2004, 2005, 2006 and 2007: Sales Dollars Margin Dollars Margin as % of sales I couldn't think of a way to display all these data on a bubble chart and recommended a combination bar/line chart instead, with the margin % shown as a line with its own Y2 axis. Was I wrong and can the above data set be displayed on a bubble chart after all? The data can be displayed on a bubble chart. However, one of the harder things for people to do is correlate the size of a bubble with a value. A combination bar-line or a line on two axes chart is a better choice. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ >A colleague of mine was asking me to use a bubble chart to show the >following [quoted text clipped - 12 lines] > after > all? Jon, suitability of a bubble chart aside: how can I even show 4 years of sales $, margin $ and Margin $ on the same bubble chart? > The data can be displayed on a bubble chart. However, one of the harder > things for people to do is correlate the size of a bubble with a value. A [quoted text clipped - 23 lines] > > after > > all? Actually, that's one more variable than fits, if year is across the bottom axis. I was writing something quick before dinner got cold. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Jon, suitability of a bubble chart aside: how can I even show 4 years of > sales $, margin $ and Margin $ on the same bubble chart? [quoted text clipped - 28 lines] >> > after >> > all? Thanks Jon, I just wanted to be certain that I didn't misspeak when I told my colleague that this data set would not fit into a single bubble chart. > Actually, that's one more variable than fits, if year is across the bottom > axis. I was writing something quick before dinner got cold. [quoted text clipped - 38 lines] > >> > after > >> > all? If you were going to use a bubble would it not be Years as series Sales Dollars on x or y Margin Dollars on y or x Margin as % of sales bubble size This assumes a single value/bubble for each year. Cheers Andy > Thanks Jon, I just wanted to be certain that I didn't misspeak when I told my > colleague that this data set would not fit into a single bubble chart. [quoted text clipped - 41 lines] >>>>>after >>>>>all?  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Andy - It would work this way, and that might be what I was thinking, but most times the chart only makes sense with years across X. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > If you were going to use a bubble would it not be > [quoted text clipped - 55 lines] >>>>>>after >>>>>>all? It is almost certainly not worth the effort, but you could have a bubble representing margin inside a bubble representing sales and use colouring to represent the percentage. This sort of chart impresses people with your knowledge without imparting much of it. >A colleague of mine was asking me to use a bubble chart to show the >following [quoted text clipped - 12 lines] > after > all? > ... without imparting much of it. LOL - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > It is almost certainly not worth the effort, but you could have a bubble > representing margin inside a bubble representing sales and use colouring [quoted text clipped - 17 lines] >> after >> all? |
Reply to this Message |
 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
|
©2009 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.