Chart with a columns

[rlmays]

Hi, I have the chart below that I am very happy with except for one thing:

.

I would like each column to be in two colors or shades using the type of order (EDI or FAX) to determine how much of the column is one color/shade and how much is the other color/shade. I don't know how to add that data to get the result that I want. I hope this makes sense.

Any help would be greatly appreciated.

 

[pplstuff]

Click on the column, change the chart type to "stacked column". Select data for the chart and choose your EDI vs Fax data. You may have to play with it a bit to still show the "PO Lines" on the chart table. Maybe set those columns transparent? (If it won't let you remove it from the chart completely)

 

[rlmays]

Thank you so much. I was able to make it work. )

rlmays