ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   creating combo charts (https://www.excelbanter.com/charts-charting-excel/138510-creating-combo-charts.html)

Joe

creating combo charts
 
In previous versions of excel (Pre 2007) you were able to create combo graphs
with both bars and lines. I dont find that option at all now.

John Mansfield

creating combo charts
 
In Excel 2007 it looks like you need to create your own custom charts and
then save each one as a template.

John Mansfield


"Joe" wrote:

In previous versions of excel (Pre 2007) you were able to create combo graphs
with both bars and lines. I dont find that option at all now.


Jon Peltier

creating combo charts
 
The built in combo charts were kind of lame anyway. Make your own. Start
with a chart using the type that appears more in your final chart, then
select each of the series you want to change and use the Change Chart Type
button on the Chart Tools Design tab to change the chart type of the
selected series.

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


"Joe" wrote in message
...
In previous versions of excel (Pre 2007) you were able to create combo
graphs
with both bars and lines. I dont find that option at all now.





All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com