• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bar (primary Y-axis) and Line (secondary Y-axis) Chart not available in MS Excel

F

fred

Member
In MS Excel 2003, if I have 2 columns of data I can set it to show one set of data as Bars and the 2nd set of data on secondary Y-axis as line.


But I'm using Excel 2007 and I can't find it where I can do the same thing!


The only solution is to set the chart as "pure" line charts where 2 lines one of each on its Y-axis.


Could someone please tell me how a bar+line chart can be found on the 2007 menu? Thank you very much.
 
Hi Fred,


After you create a fiel with the data on the same axis, right click on a data series and select Change Series Chart Type and then repeat the process and select Format Data Series. You will then be presented with various options.


kanti
 
You must log in or register to reply here.
Back
Top