Thread: Excel pros! Need some help.

Another thing that will help is to override the automatic scale min and max that Excel defaults to. Right click on the Y axis bar and get into the config window for the axis. Uncheck the auto scale box and force your own min and max values for the axis until you get the data to display the way you want.

Another option for you is to go with a 3-D bar or line graph. I think that allows you to have different y scales for each data series.

Or, you can normalize all the data to % instead of actual values. You'd have to keep track of what 100% is for each data series but then it would all display on the same 2D graph.