View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Creating a histogram and line on the same chart

Make a column chart with both sets of data. Right click on the series for
cost in dollars, select Change Chart Type, and choose a line style.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"charles" wrote in message
...
Hello,
Is it possible to have a histogram that represents quantities of a
particular subject with the y-axis representing the numerical value and
above
the histograms is a line exhibiting the cost in dollars of each the
histogram
subjects?
If this is possible how can this be accomplished with Microsoft Excel
2007?