LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Junior Member
 
Posts: 3
Default

i managed to combine bubble and scatter chart by creating two separate charts. they both have exactly same axis minimum and maximum values.

i made the bubble chart with transparent background and grid & axis lines so that the only thing that was visible on it were the bubble themselves.

then the last step was to adjust the size and position of the two charts in such way that when i position the bubble chart on top of scatter chart it aligns perfectly and it looks like they are a single chart.

hope this simple technique helps with what you want to achieve. it certainly helped me.
 
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
Overlay bar charts glennr Charts and Charting in Excel 1 November 8th 06 09:13 AM
How to Automatically Create Scatter Plot Charts Chris Gregory Charts and Charting in Excel 8 October 13th 06 03:35 AM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM
Overlay charts Ian Charts and Charting in Excel 13 March 24th 05 07:46 PM
Can I use xy scatter charts to plot absolute measurements? Wattie Charts and Charting in Excel 0 February 6th 05 03:29 PM


All times are GMT +1. The time now is 09:21 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"