| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line & Bar on Same Chart?
I have two sets of data - one set I would like to plot as a line plot,
the other as a bar plot. Is there a way to put both of these on the same graph? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line & Bar on Same Chart?
I am interested in knowing how to do this too. Is the line called a trend
line? Help in Excel says to add a trendline, you should choose "Add trend line" from the Chart menu. There is chart tool bar and chart options, but I don't know where the CHART MENU is? "Matt" wrote: I have two sets of data - one set I would like to plot as a line plot, the other as a bar plot. Is there a way to put both of these on the same graph? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line & Bar on Same Chart?
just create a bar chart using all the data and then right click on the part
of the chart you want to change to a line and select chart type from the menu and chane to a line chart. -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Matt" wrote: I have two sets of data - one set I would like to plot as a line plot, the other as a bar plot. Is there a way to put both of these on the same graph? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line & Bar on Same Chart?
When I tried this, both data series changed to a line graph.
"john" wrote: just create a bar chart using all the data and then right click on the part of the chart you want to change to a line and select chart type from the menu and chane to a line chart. -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Matt" wrote: I have two sets of data - one set I would like to plot as a line plot, the other as a bar plot. Is there a way to put both of these on the same graph? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line & Bar on Same Chart?
You have to specifically select the series you want to change. If more
series changed, then some other part of the chart was selected. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Ineedhelp!" wrote in message ... When I tried this, both data series changed to a line graph. "john" wrote: just create a bar chart using all the data and then right click on the part of the chart you want to change to a line and select chart type from the menu and chane to a line chart. -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Matt" wrote: I have two sets of data - one set I would like to plot as a line plot, the other as a bar plot. Is there a way to put both of these on the same graph? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Line Width in Line or Scatter Chart | Charts and Charting in Excel | |||
| Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
| How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
| Chart Type - Line Column adding a 2nd line | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Hybrid Mode
