Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default How do I make a combination chart in 2007 as in 2003?

Cannot work out how to make a simple combination graph like it was easy to do
in 2003. Doesn't seem to be any help on this.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default How do I make a combination chart in 2007 as in 2003?

Hi,

Combination charts are still possible in xl2007. But the default ones
presented in xl2003 have gone.
Basically you have to create the combination yourself.

Create the chart in the style that most series will be. Then selected a
series that you want to change the chart type of and then press the Chart
Type button in the Change Chart Type button within the Type Group in the
Design tab of the Chart Tools contextual tab.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ducky" wrote in message
...
Cannot work out how to make a simple combination graph like it was easy to
do
in 2003. Doesn't seem to be any help on this.


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 857
Default How do I make a combination chart in 2007 as in 2003?

Hi,

Your question also implies that you are after a dual axis chart, no?

If so:
Choose one of the series and then click the Format tab, choose Format
Selection, and under Series Options choose Secondary Axis. Repeat for each
series you want on that axis.

Cheers,
Shane

"Ducky" wrote in message
...
Cannot work out how to make a simple combination graph like it was easy to
do
in 2003. Doesn't seem to be any help on this.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pls confirm 2007 chart redraw is up to 10 times slower than 2003 larry godfrey Charts and Charting in Excel 27 September 6th 08 10:15 PM
Combination of stock chart and line chart hwatari Charts and Charting in Excel 2 September 24th 07 10:52 PM
Combination Chart sed Charts and Charting in Excel 3 January 4th 06 04:07 AM
How do you make a combination chart with 2 axis. smw Charts and Charting in Excel 1 October 6th 05 12:28 AM
How to lock combination chart in pivot chart? Marcos Novaki Charts and Charting in Excel 1 April 13th 05 10:05 PM


All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"