Hi All,

This is probably something simple, but I'm brand new at Excel charting.

I have a number of spreadsheets, each with the time of day down column
A, in 1/2 hour increments (12:00 AM, 12:30 AM, 1:00 AM, etc.). Starting with
column B, each column is a different date, out to column AD.

In the cells, my wife has recorded her blood sugar levels. Now we want
to print a chart with blood sugar on the Y axis, and times on the x-axis,
repeating over the date range. it will be a very long chart, but that's what
we're after.

How do I tell Excel to chart the data like this, with the columns
essentially concatenated to one axis of the chart?

Thabks and Regards,
Max