Hello,

I am building a big spreadsheet with a graph at the top of the data. I have too many rows to plot (more than 5 hundred) and I activate the rows (data series) I want to plot by means of checkboxes that change the TRUE/FALSE condition in a mirror table, from where the graph takes its data.

To start with, the old problem of the 255 data series limitation in a graph. I tried to overlap two graphs, making one transparent, but the problem is their axes and lines. As I have very distinct values that can vary largely (ranging from a few units to several millions from one data series to another), the axes and lines are shown together making it very messy. Is there any workaround for this problem or it's better just to split the tables?

Also, although it doesn't make sense to plot many rows (data series) together, I may need to see a total or average for a category, that may include a hundred lines/data series. I already built the formulae at the bottom of my mirror table adding and averaging every line the conditions is true (checkbox checked). Is there a way to make the graph plot this line when ever I have, say, more than five checkboxes activated?

Thanks in advance!!!