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


"sean_walsh" wrote:

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

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


On Aug 21, 1:17*pm, Eduardo wrote:
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" wrote:
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- Hide quoted text -

- Show quoted text -

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" wrote:

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


On Aug 21, 1:17 pm, Eduardo wrote:
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" wrote:
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- Hide quoted text -

- Show quoted text -

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

On Aug 21, 2:28*pm, Eduardo wrote:
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" wrote:
Well that's the problem, you can't create bubble charts from Pivot
Tables. Have you tried this?

On Aug 21, 1:17 pm, Eduardo wrote:
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" wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

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

"sean_walsh" wrote:

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

On Aug 21, 2:28 pm, Eduardo wrote:
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" wrote:
Well that's the problem, you can't create bubble charts from Pivot
Tables. Have you tried this?

On Aug 21, 1:17 pm, Eduardo wrote:
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" wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -