| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar and Line plots on the same chart
Is there a way to have some data plotted as bars and other data as lines on
the same chart? Appreciate any suggestiuions. Dave WinXP SP3 Office (Excel)2003 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar and Line plots on the same chart
Hi,
Yes, you need to plot the line as an xy-scatter in order to get the line to go vertically. with Y values being used to align the points with the bars. Cheers Andy On 12/05/2010 16:05, Dave wrote: Is there a way to have some data plotted as bars and other data as lines on the same chart? Appreciate any suggestiuions. Dave WinXP SP3 Office (Excel)2003 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar and Line plots on the same chart
Thank you Andy - it works :-)
Dave "Andy Pope" wrote in message ... Hi, Yes, you need to plot the line as an xy-scatter in order to get the line to go vertically. with Y values being used to align the points with the bars. Cheers Andy On 12/05/2010 16:05, Dave wrote: Is there a way to have some data plotted as bars and other data as lines on the same chart? Appreciate any suggestiuions. Dave WinXP SP3 Office (Excel)2003 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dual Y Axis in Line Plots | Excel Discussion (Misc queries) | |||
| line chart plots false value and the real value on same date | Charts and Charting in Excel | |||
| Why does Regression tool in '07 not display Line Fit Plots correct | Excel Discussion (Misc queries) | |||
| can i do multiple plots on 3d chart? | Charts and Charting in Excel | |||
| Excel gives me line plots - I want scatter plots | Charts and Charting in Excel | |||
Linear Mode
