troubleshooting Question

how to automatically populate an excel graph with a unknown number of variables

Avatar of Jacques Weissenburger
Jacques WeissenburgerFlag for France asked on
Microsoft Excel
14 Comments1 Solution563 ViewsLast Modified:
Hi experts,

I am using excel to collect data where variables are related to categories.. But it is up to the user to choose 2 to any number of categories.
I  ahve already created a table which contains the categories selected and two related values (X and Y in a line chart).
  CategoryA  6      5
  CategoryB  10    4
  Category E 11    9
  Category F2  3  23
etc etc

No way to know how much, and which category are used, but the table has extracted them

What I need is a way to create a scatter plot  based on that automatically-generated table
and I don't want to do it manually (because, I plot numerous scatter plots for each user)

Thanks for any help
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 14 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros