I have 2 data sets which i need to compare for a company (in a bar graph) out of which 1 data set need not to be to scale. For e.g. for various companies, i have a Market Capitalization and Cash Reserves which i need to plot but i do not need the Market Capitalization to scale on the chart (obviously due to the scaling issue int he difference of figures between the data sets). Would request inputs on the same.
Chart without Scale
- Thread starter arunraman
- Start date
In Excel 2007/2010 you can delete the scales, just select them and press delete
In Excel up to 2003 make scale color white or no color
If you want to remove the scale relativity of the 2 series multiply the smaller series values * Max(Large series)/Max(Small series). This way both series will have a common maximum value and appear as a percentage of that value.
In Excel up to 2003 make scale color white or no color
If you want to remove the scale relativity of the 2 series multiply the smaller series values * Max(Large series)/Max(Small series). This way both series will have a common maximum value and appear as a percentage of that value.