Presentation of graph from pivot, problems in standardising colors and apperance.

Hi!

Just a warning first: My native Language is not English, so there might be some bad grammar in this thread.

My case is like this: I work in a blood bank, and I have been given the task of making a spreadsheet for both registration and presentation of what we have in stock. Several people (some with little knowledge about Excel) will use the spreadsheet, so it must be very intuitively. We use Excel 2013. My main problems is to find a way to easily choose bloodtype to be shown in the diagram. The only way I can think of is to choose from "values" in the pivotmenu. The problem then is that the colour of the graph is depending on witch order they have been selected, and not their content. I would like the graph for B+ to always be green, and 0+ to be blue. Is there a way to fix this? Or perhaps a completely different way to approch the issue on?

In advance: Thank you!

Hmm...Im not able to attach the file. Sorry about that. No responce when I push the button attachment..... Is there another way?

Pivot charts are difficult to control. What I suggest is that you "overlay" the pivot results with a named dynamic range, and plot your charts off of that.

Here are two articles that will help you with that:
http://www.utteraccess.com/wiki/inde...Dynamic_Ranges
http://www.utteraccess.com/wiki/inde...namic_Charting

Then I suggest adapting the code in the attached to assure consistent charting wherever charts appear in the spreadsheet.

I would really help if you try to attach the workbook again. Make sure it isn't too big. If it is, compress it and attach the ZIP file.

With a workbook, I can assist you or walk you through the process to make the dynamic ranges and the dynamic charts and adapt the program (It's a matter of telling the code what table to look up against for color assignment).

To add a file, go to the go advanced button. Scroll down a bit and there is a manage attachment link. This will open a dialog box and you should be able to figure it out from there. Once you do upload the file, then you have to close the dialog box to continue posting.