Help with line graph

[stryped]

I am needing help recreating the attached in excel. It is showing the absentee rates for each department for both previous and current months. Attached is an excel document put with a picture off of PowerPoint. Any help is appreciated!

[Glenn Kennedy]

There are no data in the file. Please upload a sample file complete with raw data!!!!

[stryped]

Here you go. Need a chart to show and compare each department's attendance rate for the different months to each other.

Thanks!example (2).xlsx

[Glenn Kennedy]

A bit of a guess, as I wasn't really sure what you expected to see!!

[stryped]

Is there a better way to show this?

[Glenn Kennedy]

The human eye isn't really programmed to filter a massive set of squiggles and see a pattern. If I was doing this for myself, I'd display a SINGLE department at a time, using a drop-down box to select the department. However, that's not what you asked for.

IMHO the solution to the problem, as posed by yourself, looks like a dog's breakfast...

Re-define what you want and work from there.

[stryped]

How would you do the drop down?

[Glenn Kennedy]

Like this, maybe? You can hide the green cells by positioning the graph on top of the green cells.