Line Graph

[Nan]

I have 3 categories (Refractive, Topo and Patient). Each of th
categories has 5 different office locations. I would like to do a lin
graph showing total collections for each category and location b
month. For example, for the month of August each of the 5 offices ha
collections in each of the 3 categories. Is there a way to do this al
on one line graph? Will some kind of stacked chart work? Thanks for an
help. Na

 

[Jon Peltier]

It's going to be messy, not easy to read, with 15 series. Probably you have 16
columns, one for the month, the others are 5 offices x 3 categories.

You could try a stacked area chart. The total stack of 15 series will indicate the
overall monthly total.

What's the major division of the data? You might show a 5-series chart, where you
have the five offices, showing the sum of the three categories. Or a 3-series chart,
showing each category, summed over the offices. Maybe three charts, each showing all
offices for only one category, or five, showing all categories for one office each.

You could start with an overall chart, then show increasingly specific breakdowns of
the data. Sometimes it's better to use more charts with fewer series, even though
Excel lets you put 255 or 256 series on each chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______