Create or add chart data source buttons outside of chart

Hello everyone,

Is it possible to have the active/inactive check box of a Chart's "data source" outside of the chart?
(*see red circle in attached image)

We have several models to test, and each model requires 10-20 tests. I was thinking of making 1 spreadsheet per model. To not clutter the chart with too much information I would like the active/inactive buttons beside each data chart to quickly display or hide said information, and not have to open the "Select Data Source" box each time.
I would then make a new spreadsheet for each model we test.

See attached sample excel with 2 data charts.

Thanks,
David T

Hi there,

See if the attached version of your workbook gets you moving in the right direction.

Entering a non-blank value (e.g. X) in any of the yellow cells will cause the values in the associated data column to be displayed in the lower set of data values. The charts take their values from the lower set of data values, so individual graphs will appear/disappear as appropriate.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thank you Greg, I assume it's not possible to link buttons to the data source inside the chart (red circle in image at beginning of thread)?
If that's not possible, the file you uploaded will do just what I need after some small tweaks.

On another note, is there a way to add a "scale" beside the y or x axis that wouldn't require stacking charts or adding images manually?
I would like to display 2 units, the secondary unit would be dynamically linked to the first (the attached image is made with photo editing just to visualize). The primary unit is GPM "gallons per minute" and the secondary LPS "liters per second"

Many thanks,
David TAttachment 745645

Hi again David,

Thanks for your feedback.

The attached workbook includes (on the chart) buttons which toggle the visible/hidden states of the individual graphs. They are all located at the top of the chart rather than at the end of each graph (which would be significantly more difficult to achieve.)

On another note, is there a way to add a "scale" beside the y or x axis that wouldn't require stacking charts or adding images manually?
I would like to display 2 units, the secondary unit would be dynamically linked to the first (the attached image is made with photo editing just to visualize). The primary unit is GPM "gallons per minute" and the secondary LPS "liters per second"

As far as I know (which don't necessarily make it so! ), although you can have a secondary Y-axis, it's not possible to have a secondary X-Axis, so I've provided a cell which you can use to select either "Gallons" or "Litres", and the scale and legend of the X-Axis will update appropriately. (I'm happy to be corrected by anyone who knows that a secondary X-Axis can be provided )

Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

Thank you Greg!

The buttons are exactly what I need.

On the second topic, what if it is not an axis but a dynamic shape/line? Not sure what to call it but it would have the same length as the x axis and it would convert from GPM to LPS and adjust the tick marks accordingly.

Best Regards,

David T

Hi again David,

Thanks for your feedback - glad to hear that the buttons are doing what you need.

As far as the second point is concerned, I think that trying to create a "do-it-yourself" adjustable X-axis complete with tickmarks, and values would be quite a complicated undertaking

I'm quite happy to be corrected/educated by someone who's managed to achieve something like this

Regards,

Greg M

I'm quite happy to be corrected/educated by someone who's managed to achieve something like this

Thanks, Andy!

Regards,

Greg M

Thank you Greg and Andy, with this I can run a much more efficient analysis.

Best Regards,
David T

Hi again David,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Regards,

Greg M