View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Connie Martin
 
Posts: n/a
Default Combination Chart

Just found the answer in a previous post, and through Help in Excel. Connie

"Connie Martin" wrote:

I would like to do a chart that combine quantity and value. For instance, my
data is the number of sales orders per month and the dollar value for each
month. If I have 265 sales orders and over $2 million is sales for that
month, an ordinary bar chart doesn't work, obviously because we're comparing
apples and oranges. However, is there another way to show both of these on
the same chart? Hope I have explained myself. I wondered about the pie of
pie chart, but don't know how to possibly set it up. Connie