| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a histogram and line on the same chart
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating stacked column/line chart combinations | Charts and Charting in Excel | |||
| Creating Average Line on chart | Charts and Charting in Excel | |||
| Vertical line in a histogram (vertical bar chart) | Excel Discussion (Misc queries) | |||
| I was creating a histogram; now i have data but no histogram. | Excel Worksheet Functions | |||
| Creating a line chart with two X-axes!! | Excel Discussion (Misc queries) | |||
Linear Mode
