3 Factors Analyzed

[Bonnie]

I need to create a chart that can be analyzed or visualized that has 3
dimensions of a sort.

(1) I have a list of items (which can grow)
(2) I have set of 5 working conditions in which each item must meet one of
the five
(3) but they also get analyzed for the condition daily - so I need to add a
date range - and it happens twice a day (AM & PM).

I haven't been able to figure out how to cleanly get all this data into a
table, let alone create a chart from it.

HELP!

 

[Pete_UK]

Hi Bonnie,

I think you need a clearer idea of what you want to end up with, and
from there you could design how the data could be recorded to suit the
outputs.

You might, for example, have five graphs one for each of your working
conditions, and then you are plotting date against the list of items.

Another approach would be to have 5 (or 7 ?) graphs one for each day,
where you plot working condition against day, reporting on a weekly
basis. You might want to superimpose data from the previous week, or
even from all weeks in that month.

You could have both of these (on separate sheets, and others) to show
your data from different points of view.

It's a bit difficult to give you specific advice, given that your
description was a bit vague.

Hope this helps.

Pete