Hi All,
I have used the following model to create a somewhat complicated workbook of my own:
http://www.andypope.info/charts/piezeros.htm
However, I need to graph two time periods that don't necessarily have A-G.
Its more like a top 10 costs bar chart and sometimes the top 10 of last year doesnt match the top 10 of this year. I want it to show up as a 0% for which ever year it wasnt a top ten if it was in another.
Say for one time period we have labels A-G but in the other we can have A,B,C,D,E,F,Hhow would you make a chart that includes H for one time period where theres a value and G in the other, thus accounting the top ten of THOSE respective time frames?
Meaning, you would have Period 1 and Period 2 on one chart showing A,B,C,D,E,F,G,H, H for one or the other comes up as Zero and the other H comes up as the % cost etc.
I have used the following model to create a somewhat complicated workbook of my own:
http://www.andypope.info/charts/piezeros.htm
However, I need to graph two time periods that don't necessarily have A-G.
Its more like a top 10 costs bar chart and sometimes the top 10 of last year doesnt match the top 10 of this year. I want it to show up as a 0% for which ever year it wasnt a top ten if it was in another.
Say for one time period we have labels A-G but in the other we can have A,B,C,D,E,F,Hhow would you make a chart that includes H for one time period where theres a value and G in the other, thus accounting the top ten of THOSE respective time frames?
Meaning, you would have Period 1 and Period 2 on one chart showing A,B,C,D,E,F,G,H, H for one or the other comes up as Zero and the other H comes up as the % cost etc.
Last edited:
