If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need to combine a bubble chart and a line graph (Excel 2003)
I have a simple data set of:
Column A: X axis Column B: Y axis Column C: Bubble width I have the bubble chart complete. Now, I want to plot the X/Y axis data as a line graph OVER the bubble chart to show the sequence of the data points from start to finish. Excel HELP is no help. Is there a way to make a second graph (the line graph), change the background to "transparent" and then copy it over the bubble graph? Or, is there a better way to get what I need? Thanks for any help! |
#2
|
|||
|
|||
Bernard showed how to make one chart transparent in your other thread. I have a very
simplistic macro that will do this for you: http://peltiertech.com/Excel/Charts/AlignCharts.html You can also fake a bubble chart by using custom sized circles as markers on your line chart, following the procedure in this article: http://support.microsoft.com/default...b;en-us;139662 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Rippbird wrote: I have a simple data set of: Column A: X axis Column B: Y axis Column C: Bubble width I have the bubble chart complete. Now, I want to plot the X/Y axis data as a line graph OVER the bubble chart to show the sequence of the data points from start to finish. Excel HELP is no help. Is there a way to make a second graph (the line graph), change the background to "transparent" and then copy it over the bubble graph? Or, is there a better way to get what I need? Thanks for any help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
paste excel 2003 chart into powerpoint | Nick F | Powerpoint | 1 | September 14th, 2004 05:12 AM |
Excel 2000 Line Chart Problem...HELP !!!! | Tushar Mehta | Charts and Charting | 2 | May 13th, 2004 12:12 AM |
Discontinue part of line in chart | Jon Peltier | Charts and Charting | 0 | April 1st, 2004 10:27 PM |
Trying To Add a Line to an Excel chart using variable cell values | Larry Campbell | Charts and Charting | 2 | January 24th, 2004 06:31 PM |
Chart Doesn't Appear when Excel started from Command Line | mitchamm | Charts and Charting | 3 | December 7th, 2003 04:55 AM |