ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel Charting
BubbleChart problem BubbleChart problem
Register FAQ Forum Rules Members List Calendar Search Today's Posts Mark Forums Read

Notices
Hi All,
The big green guy here, just wanted to let you all know that we now have the reputation system in place, the reputation system allows you to give a visible pat on the back to those that have helped you or whose information has been helpful.

You will see an icon in every post (Light Blue scales), click this to give the reputation point to whom you think deserves it, a green square appears for a reputation with more and more adding over time.Pretty soon you will see a string of green squares appear in the top right of your posts as your reputation grows and your forum presence!

Good Luck!
The Hulkster!

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 08-18-2008, 07:12 PM
wyahaw wyahaw is offline
Registered User
  
Join Date: 18 Aug 2008
Location: London
Posts: 2
wyahaw is on a distinguished road
BubbleChart problem
I am having a weird problem in Excel 2007 with bubble charts. I have three columns of data I want to display,and all are in the range 0 - 6 (numeric values). I'd like the third column to be the size of the bubble, the first two to be the x and y axes. When I drawn this the bubble chart comes up with an x scale of 20, not of 6, despite all the data being <=6. I am doing something stupid, or is this a bug? Is there a way around this?

Apologies in advance if this is obvious but I have been looking at this for some time and am baffled. I attach a sample showing the problem.
Attached Files
File Type: xlsm test bubble chart.xlsm (13.2 KB, 2 views)
Reply With Quote
  #2  
Old 08-19-2008, 04:48 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
  
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,305
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
Your data series includes the text in row 1. This has the effect of ignoring the values in column B as the X position. Instead the X position is a sequential value 1 to 15.

Adjust the series data bounds to exclude the first row and the chart will correct itself.
__________________
Cheers
Andy
Reply With Quote
  #3  
Old 08-19-2008, 07:42 AM
wyahaw wyahaw is offline
Registered User
  
Join Date: 18 Aug 2008
Location: London
Posts: 2
wyahaw is on a distinguished road
Thanks!
Ah, is that all it was! Thank you so much for taking the trouble to look at this; it has saved me lots of time and heartache. Much appreciated.
Reply With Quote
Reply

Bookmarks

Tags
bubble chart

New topics in Excel Charting

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel date problem hermiod Excel General 4 07-16-2007 11:22 AM
Cut and Paste Problem agila916 Excel Miscellaneous 4 07-09-2007 06:36 PM
Excel 2007/ Outlook 2007 mail Problem Bostock Excel Programming 2 06-25-2007 05:26 PM
Countif funtions problem mike4545 Excel Worksheet Functions 4 06-17-2007 03:37 PM
Cell function problem itty Excel Worksheet Functions 2 05-19-2007 09:27 AM


All times are GMT -4. The time now is 06:13 PM.

Contact Us - ExcelTip.com - Archive - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0