Conditional hiding of columns

Hi Mike,

One idea is to have a 'Diary' table with all the details. Column B is a Pop-Up Menu

Another table 'Summary' can "pull" the key data columns, that you can perhaps use in a graph (chart)

For example,

=Diary::$A2

Please call back with questions. There are many positive helpers in this forum.

Regards,

Ian.

Hi Mike,

You are not thick 🙂.

This works in OSX El Capitan and MacOS Sierra.

'Diary' is not a function or an app. it is a table name.

Pop-Up Menu is a cell format

Select a list of Meals and Format Panel > Cell > Data format > Pop-Up Menu

More tomorrow, I must go to bed.

Happy Numbering and regards,

Ian.

Hi Mike,

"Diary" is the name of the table on which the data is collected. The diary table contains only entered data—Date and Time, Meal, Food, Carbohydrates, Insulin and Blood Sugar.

Ian suggests using a pop-up menu for the Meal column as it will contain a limited variety of entries.

The Summary table is used to pull data from only four of the columns—Date and Time, Carbohydrates, Insulin, and Blood Sugar. These four columns can be used to create a single chart (graph) plotting the last three values against the times that the readings were taken. The chart will be an xy scatter graph, with three series sharing the x coordinate values in column A. Data points in each series will be connected by a curve.

You can learn more about charts by creating a document from the Charting Basics template and studying the examples there.

If you'd like an example of the specific chart described here, please copy several lines of data from the Diary table or equivalent) then paste it directly into the page of your reply, where it can be selected, copied, and pasted into a table from which a chart can be constructed.

Regards,

Barry