View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
wildetudor wildetudor is offline
external usenet poster
 
Posts: 20
Default scaling of columns: same maximum height despite different ranges

When plotting several variables on a single chart (e.g. each category on the
x-axis has three clustered columns), and the value ranges of the three
variables are very different, is it possible to have Excel scale each
variable such that they are all represented by columns of comparable height
in the graph (i.e. the maximum value of each is represented by a column of
the same height)?

To illustrate this rather abstract question, I have created this example
chart (in Excel, then I added the values in a photo editor), in which I
compare three variables (CPU rating, GPU rating and weight) for four
different laptop models -- http://www.badongo.com/pic/5057464

Thanks for any help.