Advice on Graphs

[Bloodrayne]

Hi all,

I'm currently making a pretty Excel graph but I've just thought of a new way to present the data - however, I am not sure how to go about it.

Basically, I have month and quantities of items shipped on that month - but I also have the history of the previous years and wanted to also add lines to this graph indicating high, medium and low peaks of previous years - so the numbers would be something like:

            Part(a)      Part(b)      Spare(c)

January  5              10            20
High      8               20            40
Mid       5               15            22
Low      1                5             10

Ideally this would be as a line graph so you could see how the current year was faring against past performance records - obviously I'd have to work on a colour scheme to make things clear, but first of all, is this even possible?

Am I just having a complete brain freeze with Excel today and this is actually really easy to do?

 

[noboffinme]

Hi Bloodrayne,

As you have 3 dimensions of data, Month, Level & Part, I suggest a Pivot Chart to do what you need.

This involves some slightly different formatting of your data, creating a Pivot table from that table, & Inserting a Pivot chart onto the Worksheet to get your line graph.

I've attached an example & I created some extra data to show the graph over a few months. HTH

I've created this in Excel 2007 btw.