Dynamic chart in Analysis Powerpoint

[former_member323627]

Hi experts i’m experiencing an issue regarding dynamic charts un Analysis PowerPoint, after y press the button to convert crosstab into a chart it prompts an excel worksheet and it is not taking the entire ammount of columns contained in my crosstab, i’ve tried adjusting the data,but,once that the data source is refreshed the chart again restore his deffaults,this issue is only for PowerPoint in Excel the chart changes according the crosstab without problem.

[TammyPowlas]

Hi Luis - would you please share version of Analysis (e.g. 2.5), PowerPoint version (e.g. Microsoft 2016) and use the image icon to upload screen shots? Thank you

[former_member323627]

Analysis Version 2.5 SP2

Office 2016

Power Point chart looks like this

And Excel chart with the same query,looks like this

As you can see, Power Point is not taking columns 4,5,6 and 7

[TammyPowlas]

Hi - thank you for sharing. Would a bar chart (as opposed to a column chart) be a better fit? Could you try that?

[former_member323627]

I've already tried the solution proposed,but still it is not working,this is the result when i tried to change the chart type

[TammyPowlas]

I think you will need to go full page in PowerPoint for all of it to appear as a full chart.

[former_member323627]

I've already tried that, i think that the problem is not graphical but of the way the chart in PowerPoint is reading the Excel genereted by the crosstab,always takes the same ammount of columns(3) no matter how many columns returned by the data source. In Excel always that the crosstab changes the chart adjusts accordingly the ammount of columns

[TammyPowlas]

How are you building the chart? Are you using Smart Paste?

[former_member323627]

I've tried since creating directly from Power Point to use the Smart Paste feature, in all scenarios the result is the same, also tried other Analysis and Office versions but in every one of them the result is the same.