Microsoft Office Forums Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2018, 06:39 AM
Ismailc@parmalat.co.za Ismailc@parmalat.co.za is offline Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option Windows 7 32bit Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option Office 2013
Novice
Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option
 
Join Date: Sep 2018
Posts: 1
Ismailc@parmalat.co.za is on a distinguished road
Question Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option

Good day,



I need help please, I need to create Dynamic Scatter graphs for 100 user using the excel template.

Initially thought I could create the scatter from pivot table (olap)

Scatter doesn't like pivot table (PowerQuery not at option), my data is dynamic so I read insert data into data table and as table increase or decrease the scatter will change.

i want the data table to read from pivot table, every time pivot table changes the data table changes

Any ideas?

Regards
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Hyperlink Infopath 2013 palvayisrikanth Misc 0 11-11-2015 11:48 AM
Dynamic Pivot Table in 2013 Alaska1 Excel 0 01-29-2015 10:33 AM
Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option finding the data source for a scatter graph Natalie728 Excel 1 01-29-2015 09:21 AM
New email option Outlook 2013 mawallace Outlook 0 03-26-2013 04:06 AM
Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option how to display Timestamp on x-axis in Scatter smooth line graph bugserm Excel 1 01-23-2012 02:28 AM


All times are GMT -7. The time now is 02:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft