Chart data range is too complex

Giordano Bruno

Well-known Member
Joined
Jan 7, 2007
Messages
1,257
I have seen several posts about this, but they do not address my question. The graph in question has been created by someone else and I need to know the data which they have used. If I know what it was, I could simplify it, but first I need to have some sort of clue where it comes from. Is there a method of finding this information some other way than just interrogating the charts "Delect Data"?
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
right click a data set, add data, then select a name and edit, that should show you
 

Giordano Bruno

Well-known Member
Joined
Jan 7, 2007
Messages
1,257
Hi mole999. Thanks for the interest, but it is the "data set" that I want to find. "Select data" just gives me the message that the range is too complex so I need another method for finding the data that is feeding into the chart.
 

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
how many lines being modelled, maybe destroy a copy to reduce the number down to something excel will reveal
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,887

ADVERTISEMENT

Hi Giordano

When you click on a series what does the series formula show?
 
Last edited:

Giordano Bruno

Well-known Member
Joined
Jan 7, 2007
Messages
1,257
Hi mole, I don't know how many lines are being modeled as I have no idea where the data is coming from.

Hi pgc01, Thanks for the reply, but what does "click on a series" mean. If I place the cursor on the graph line, it says "Series 1 Point 29 value 7%". Clicking the line has no effect.
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,887

ADVERTISEMENT

Hi

Clinking on the line should display the series formula in the formula bar.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,673
Messages
5,838,707
Members
430,566
Latest member
ChanchalSingh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top