Excel Bubble Chart/Graph from Pivot Table

  • Thread starter Thread starter sean_walsh
  • Start date Start date
S

sean_walsh

Hi

I'm building an Analysis Services project, the data from which will be
accessed via Excel. I specifically need to produce bubble charts from
the data, but from what I can see, you can't do this from pivot
tables, which is how the data is retrieved from SQL Server Analysis
Services.

Is there a workaround, or a way that I can sort this out?

Thanks
Sean
 
Hi,
Are you using excel 2007, if yes, position in the pivot table, insert,
selecyt the chart
you want, then you can cut the chart and paste it in a different sheet

if this helps please click yes, thanks
 
Well that's the problem, you can't create bubble charts from Pivot
Tables. Have you tried this?
 
Hi,
I am actually using it, as I mention I cut and paste the chart in different
tabs and then combined the spreadsheet with a menu with buttons so the user
can select wich graph to look at
 
Very strange. I get a message saying:

"You cannot use an XY (Scatter), Bubble, or Stock chart type with a
chart that has been created from PivotTable data. Please select a
different chart type"

This happens as soon as I click the Scatter or Bubble chart from the
Insert ribbon, in Excel 2007, when positioned on a pivot table.

In other words, it doesn't generate any graph to cut & paste, it
errors with the above message as soon as I try.

Regards
Sean
 
Hi Sean,.
sorry I misunderstood you, my chart is not a buble, I try to change mine to
a buble and it didn't work gave me the same message than you
 
Back
Top