Creating a histogram and line on the same chart

C

charles

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?
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top