98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dynamic source data for scatter graph
Dynamic source data for scatter graph
Resolved · Medium Priority · Version 2010
Thu 29 Sep 2016, 17:04Delegate Jordan said...
Jordan has attended:
Excel Advanced course
Dynamic source data for scatter graph
The source data from which scatter graph is pulling from alters based on a drop down list.
I require my set data range in the scatter graph to alter accordingly, as presently the scatter graph will either miss data or hold extra data valued at 0. can you please help??
Fri 30 Sep 2016, 18:51Trainer Doug said...
RE: Dynamic source data for scatter graph
Hi Jordan
I'm sending you an example I've set up to show how to not display zero data in the scatter chart.
If this can't be applied then send a version of your file.
Sorry I can't be of more help for now.
Regards
Doug Dunn
STL
Attached files...
Dynamic Scatter chart.xlsx
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Seeing named ranges as part of the zoomIf you have large areas of named ranges this works better. |
