Excel Bubble Chart/Graph from Pivot Table

[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

 

[Eduardo]

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

 

[sean_walsh]

Well that's the problem, you can't create bubble charts from Pivot
Tables. Have you tried this?

 

[Eduardo]

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

 

[sean_walsh]

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

 

[Eduardo]

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