NUMBERS INTERACTIVE SCATTER CHART

Since 0-23 are fixed intervals I'm thinking you may do better with a category chart than a scatter chart. Perhaps something like this?

Rather than try to reinvent the wheel I started with the Interactive Chart in the 'Charting Basics' template at File > New in the menu.

Because over time the number of dates is like to exceed the number of hours, and too many columns gets unwieldy in Numbers, I transposed the data table using Table > Transpose Rows and Columns.

Clicking the chart and then the 'Edit Data Reference' rectangle button gives you this, where you can add more data rows/columns to the chart:

Now you can click through the dates and see the pattern by hour for each day.

But suppose, say, you want to see your usage at hour 1 for several consecutive dates. No problem. Click the 'Plot Rows as Series' at the lower left and change it to 'Plot Rows as Series.' Now you can click through the hours and see what the level was for that hour on consecutive dates in your data table.

SG

Hi Leann,

I have something for you to consider. See if this is what you had in mind, or if it's close.

We have a chart that can step through the dates for which you entered energy data.

It all starts with an input table where you record your energy for the day after entering the date.

This example there have been 18 entry days. They didn't have to be consecutive. If you miss a day, it's fine.

This data is used in the Chart above, which I arranged in a separate Sheet just for appearance.

I used a Stepper format rather than the slider you asked for. I found the Slider to be inconvenient by comparison. You could use either.

Column A of Energy Log calculates rank numbers for the dates using this expression:

=IFERROR(RANK($B3, B,0), "")

That's what makes the scheme work well with missing days.

This Table on the Chart Sheet references data on the Energy Log table for Charting.

Each cell in Row 2 of the Chart Table has this expression, which pulls data from the log based on your desired date:

=LOOKUP(Energy Data Date::$A$1, Energy Log::$A, Energy Log::B)

Note that this expression's LOOKUP function is looking for a value in Energy Data Date. That's the Stepper cell's Table:

What you see above is an overlay of Energy Data Date stepper and another table with one cell that just displays the date so you can watch it as you operate the Stepper control.

Here are the two, pulled apart and side by side.

Energy Data Date has no expression, just the Stepper format in its only cell.

Another single cell table has the simple function of turning Red conditionally if the Stepper value exceeds the number of Date entries so that you will know to stop incrementing the stepper.

This little indicator has the following expression:

=MAX(Energy Log::A)

and the following Conditional Format:

Below you can see the relationship between the Chart and the Chart Table.

I'm sure you noticed that I used a Bar Chart rather than a Scatter Chart. Just my preference for this type of data. I hope that what I've created for you here is close to your need. If you like it, I'd be happy to help you re-create it there.

Regards,

Jerry