• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Graph required from data in Excel 2003

In the attached spreadsheet is a tab called 'Master Sheet', this shows me products that are faulty and the reason they are faulty, column J shows me the error codes which are taken from the worksheet 'Error Code'.  What I would like to do is make a graph on the 'Analyse' worksheet which shows me month by month (Month is in column F) each of the currently 29 error codes in a different colour so I can monitor if things are getting better or worse.

If someone could do say 2 for me I could probably work out how to do the rest.

Many Thanks!
grn-spreadsheet.xls
0
Simonrepro
Asked:
Simonrepro
  • 4
  • 4
1 Solution
 
Rory ArchibaldCommented:
I'd use a pivot chart with a filter for error code rather than attempting to plot them all on one chart.
grn-spreadsheet.xls
0
 
SimonreproAuthor Commented:
This is far too complicated for me.
0
 
Rory ArchibaldCommented:
Not much I can do about that - you need a pivot table since you have multiple dates per code per month (or you need to set up a formula table with all possible month/code combinations.
Not really sure what is so complicated about it though - only took a couple of minutes to set up.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
SimonreproAuthor Commented:
I don't really want to use a pivot table, is there another way of doing it please?
0
 
Rory ArchibaldCommented:
Here's a formula version.
grn-spreadsheet.xls
0
 
SimonreproAuthor Commented:
That's great, thank you very much.  Is there any chance you can make the date like Apr-11, May-11 etc then I can just drag it along please?
0
 
redmondbCommented:
Hi, Simonrepro.

I'd produced the attached before I saw your last post. Anyway, an alternative FWIW...
grn-spreadsheet-V2.xls
Regards,
Brian.
0
 
Rory ArchibaldCommented:
Revised version. Chart should update as you add months.
grn-spreadsheet.xls
0
 
SimonreproAuthor Commented:
Fantastic, thank you!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now