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??
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