Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 09-16-2018, 06:39 AM is offline Windows 7 32bit Office 2013
Join Date: Sep 2018
Posts: 1 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?

Reply With Quote

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 05:30 PM.

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