LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy62
 
Posts: n/a
Default Bubble Charts with two non-numerical variables

I cannot figure out how to get a bubble chart to do what I want. I have two
variables, Impact vs Cost. Each of the two variables is coded as "Low",
"Medium", or "High". The third variable, which would be the size of the
bublles in the bubble chart, is the number of items for each of the nine
cells in the resulting 3 X 3 grid. Here's the source data:

High 1 0 1
Impact Medium 1 2 1
Low 4 1 1
Low Medium High
Cost
I just can't figure out what to put into the data sources panel as the X,
Y, and Sizes variables in order to get a chart with bubbles and the right
labels. I only get numbers on the axis (1, 2, and 3) instead of High,
Medium, Low. I tried something like ={"High", "Medium", "Low"} but that
didn't work. Anyone know how to pull this off? Or that it is impossible and
I should stop trying? Thanks in advance.
 
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
labels for bubble charts RickSubber Charts and Charting in Excel 2 May 1st 06 08:36 PM
Bubble Charts Colours go wrong Darren. Charts and Charting in Excel 1 March 10th 06 12:14 PM
data table - lines variables for DB functions, charts.. etc.. Marina Limeira Excel Discussion (Misc queries) 0 January 20th 06 10:20 PM
Assistance with bubble charts Mark Excel Discussion (Misc queries) 3 July 6th 05 12:33 AM
Bubble Charts - Different Shapes [email protected] Charts and Charting in Excel 3 May 25th 05 09:02 PM


All times are GMT +1. The time now is 01:35 PM.

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

About Us

"It's about Microsoft Excel"