Skip to Content

Dynamic chart in Analysis Powerpoint

Oct 28, 2017 at 01:36 AM


avatar image

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.

10 |10000 characters needed characters left characters exceeded

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


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

pperror.jpg (196.8 kB)
exerror.jpg (67.8 kB)
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Oct 28, 2017 at 07:53 PM

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

Show 5 Share
10 |10000 characters needed characters left characters exceeded

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

ppbar.jpg (86.3 kB)

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


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


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


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.