troubleshooting Question

Dynamic Chart Source Data

Avatar of Brent
BrentFlag for United States of America asked on
Microsoft Excel
3 Comments1 Solution416 ViewsLast Modified:
Hello,

I am pretty close, but I have something messed up in my name range, so my chart is wrong. My Data is listed in a worksheet, while my chart will be part of a mini dashboard on another worksheet. The top chart (chart!) is my attempt to create a dynamic source for the chart. The bottom chart is a simple example of what I am trying to do.

my name range:

=OFFSET(Data!$F$2,0,0,COUNTA(Data!$F:$F)+1,COUNTA(Data!$2:$2)+1)

Then I set my chart data source to:

=data!ChartTest

But, I am still getting the formulas listed in my chart.

I am not certain if I need to create an offset for each series (test score, average), then assign each series as the chart source data. In my reading, I have seen it both ways. The examples are always a bit different, so hard to know exactly what fits.

**After more reading, I think I might need to set up a name range for the data labels and each series (score and average). I can see my formula above is looking for both  the column and the rows, but I found many more examples on how to do it separately. Ideally, I would like to learn how to combine the function, so I can be more versatile in my approach. I totally get what I am trying to do,  but just missing something to make it click.

Thanks,
Brent
EE-dyanmic-chart-range.xlsm
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 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 3 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