Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

dynamic source data scatter

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dynamic source data for scatter graph

Dynamic source data for scatter graph

ResolvedVersion 2010

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

Attached files...

Dynamic Scatter chart.xlsx

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.