History of some of my Excel faux pas (boo-boos) 4

[SkipVought]

As I recall, it was 6-7 years ago the last time I did something like this. I was actually plotting manufacturing part inventory:
1) on hand (on primary)
2) requirements (negative stacked column chart type on primary y-value axis)
3) replenishment (positive stacked column chart type on primary y-value axis)
4) shortages (negative stacked column chart type on secondary y-value axis)
5) surpluses (positive stacked column chart type in secondary y-value axis)



Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[SkipVought]

Doug,

I did this for a former colleague from Bell Helicopter a couple years as an example of what he could expect. Unfortunately this chart example actually uses a category axis, because I aggregated the chart data point values by week. The axis can be changed to a DATE axis type and the plot is proportionally accurate but not visually impactful.

If you want to check it out, enable macros, select the cell containing RP-RQ Surplus-Shortage Forecast Chart in the Dashboard.




Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[IDS]

Thanks, I'll have a look.

This article by John Peltier also looks relevant:

http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[SkipVought]

I have found John Walkenbach's Excel Charts book very enlightening for making charts do extraordinary things.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}