View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tedasu Tedasu is offline
external usenet poster
 
Posts: 2
Default Bubble Chart best fit Scatter plot

I need to create a scatter plot that will have an oval shape bubble that only
circles the top 75th percentile date ponts. I currently have a scatter plot
with data points and then I use an excel object (oval) and size it manually
over the chart to fit the top 75th percentile data points. Is there a
functions or VBA code I can use to create this best fit oval automaticaly or
some type of trick I can use in excel? Thank you