ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel Charting

Notices

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 08-17-2008, 11:01 PM
AccountantCost AccountantCost is offline
Registered User
 
Join Date: 28 May 2008
Posts: 9
AccountantCost is on a distinguished road
Bar - Line Graph Combo

I have four data sets that I want to graph with a bar - line graph.

I want to have three of the data sets graphed with a bar graph on the primary axis. The last data set, I want graphed with a line graph on the secondary axis.

My problem is that I can get two of the three data sets showing as bar graphs. The third data set wants to show itself as a line graph.

How can I get all three data sets to show as a bar graph while keeping the last data set as showing as a line graph?
Reply With Quote
  #2  
Old 08-18-2008, 04:59 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
 
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,305
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
If you are trying to use the built-in combination charts, don't.

It's much easier to create your own combination chart.
Select all the data and create a bar chart.
Select and change the last series to Line
Format the line series to be on the Secondary axis.
__________________
Cheers
Andy
Reply With Quote
  #3  
Old 08-18-2008, 11:25 PM
AccountantCost AccountantCost is offline
Registered User
 
Join Date: 28 May 2008
Posts: 9
AccountantCost is on a distinguished road
Thanks for the help !
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


All times are GMT -4. The time now is 06:20 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0