Line chart with Bubble data points

  • Thread starter Thread starter DaSkiDude
  • Start date Start date
D

DaSkiDude

I have to create a chart in excel that shows the performance of a
stock over a year then I need to add in bubble data points on top of
that to show individual trades with the area showing the size of the
transaction.

Anyone have any ideas?


Thanks.
 
Hi,

Unfortunately bubble charts do not allow lines to connect the bubbles or for
the chart to be part of a combination chart.

You could use a xy-scatter and then some code to adjust the marker size.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Bubble chart labels on x axis 2
Adding labels to a bubble chart other than the X, Y or Z values 3
Excel Bubble Chart/Graph from Pivot Table 5
Making a Bubble Chart with 4 variables instead of 3 1
Chart to show totals by monthly when source data is by day 1
Bubble Charts - Series and Bubbles Missing (sometimes) 2
Bubble Charts 3

Back
Top