Home » Forums » Open Source Learning Center » Question and Answer

Pivot Table / Graph help

Submitted by JackieV on 6 December, 2012 - 07:59

I have excel 2007 and I am needing to make a line graph showing year on year variations in attendance for different sporting classes. Example below

Name of Class 2007 2008 2009 2010 2011
Ballet 40 75 80 15 3
Kung Fu 188 12 89 33 78

I would really like all the names to be in the left hand column and be spaced apart enough to show if a program is doing better/worse/or staying the same year on year. Any help would be greatly appreciated!

‹ cell to display the date Thank you very much ›
»

A line chart and conditional

Submitted by AndyLitch on 6 December, 2012 - 08:09.

A line chart and conditional should do the trick..

Chart
Highlight the data table
Select "Insert" -> "Line Chart"

Conditional Formatting (assuming the table is in cells A4:F6
Cell B5
=B5>A5 Format Green
=B5

»

Hi Andy, Thanks so much for

Submitted by JackieV on 6 December, 2012 - 09:00.

Hi Andy,

Thanks so much for answering me so quickly! Can you give me more of a step by step process? I created a line chart but the conditional formatting field goes away when once I create the chart. The fields I am working with are A through F with A being the name of the class and B through F being the years. I have 26 classes in total.

»

Jackie send me your file to

Submitted by AndyLitch on 6 December, 2012 - 09:03.

Jackie

send me your file to AndrewLitchfield@Gmail.com and I'll set it up and write up a few notes for you
It's easier that way :-)

»