Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-16-2018, 06:39 AM
Ismailc@parmalat.co.za Ismailc@parmalat.co.za is offline Windows 7 32bit Office 2013
Novice
 
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
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
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 04:13 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft