Any idea why a specific column doesn't appear on a graph widget?

Steven Musselwhite · 04/15/21

I've tried copying a similar graph widget, then changing the source columns, but only 1

of the 2 Y axis data sets appear (X axis is the date).

Paul Newcome · 04/15/21

Have you checked your main setting for the chart?

Steven Musselwhite · 04/15/21

Thanks for the reply, and yes it is there. That's what is so puzzling that it doesn't show when i look a the Series data

Paul Newcome · 04/15/21

Try turning it off so that it does not use the first column for the series labels.

Steven Musselwhite · 04/15/21

no...just figured it out. It was because in my formula on the Sheet, I had: IF( Between Date x and y), "98"... I had the number in brackets which was interpreted as text....rookie mistake!

Thanks for your help though

!

Paul Newcome · 04/15/21

Yep. That'll do it for sure. Glad you were able to catch it. 👍️

Any idea why a specific column doesn't appear on a graph widget?

Answers

Categories