Richard has a Data Series Set up with Year, Female, Male; after moving from Excel 2003 to Excel 2007, Richard noticed that the Chart is giving three (3) Series instead of two (2). With a few simple clicks, Bill "MrExcel" Jelen solves the additional series issue.
Something New for 2012! "CFO EXCEL PRO": a New, weekly e-Newsletter Publication from CFO.com featuring Bill "MrExcel" Jelen! CFO Excel Pro offers, "... clear, concise illustrated articles written by Microsoft MVP Bill "Mr. Excel" Jelen that provide readers with step-by-step solutions to nagging "real-world" Excel problems.
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Something New for 2012! "CFO EXCEL PRO": a New, weekly e-Newsletter Publication from CFO.com featuring Bill "MrExcel" Jelen! CFO Excel Pro offers, "... clear, concise illustrated articles written by Microsoft MVP Bill "Mr. Excel" Jelen that provide readers with step-by-step solutions to nagging "real-world" Excel problems.
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Transcript of the video:
MrExcel podcast is sponsored by the Excel Pro Weekly Excel Newsletter published by CFO and written by me.
Learn Excel From MrExcel, Podcast Episode 1511: Chart An Extra Series.
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen from mrexcel.com.
Today's question sent in by Richard.
Richard has a data series that looks like this -- YEAR, FEMALES, and MALES -- and he noticed when he switched from Excel 2003 to Excel 2007, because he doesn't get to go through the chart wizard, the default chart is giving him 3 series instead of 2.
There's the MALES, there's the FEMALES, but then, oh, there's the YEAR, and Richard actually wrote in because he had a nice little solution using data text to columns, choosing text, and then it would work, but I said, Richard, you're not going to believe this.
This is so arcane.
There's an even better solution, and you have to pull the solution out any time that the leftmost column is completely numeric or completely dates, which, of course, dates are numbers, and all you have to do is get rid of cell A1, even if you just do it temporarily, and choose that range, INSERT, LINE, LINE CHART, and look at that.
We get FEMALES and MALES and the YEARS are understood.
Of course, once you have the chart created, then you can come back up here and put your heading back like it should be.
All columns should have headings.
Just a bit of a hassle that you have to go through and remove that top left corner cell.
Again, any time that the leftmost column is completely numeric or dates, you'll want to do that.
Well, hey.
I want to thank Richard for sending that question in and I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
Learn Excel From MrExcel, Podcast Episode 1511: Chart An Extra Series.
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen from mrexcel.com.
Today's question sent in by Richard.
Richard has a data series that looks like this -- YEAR, FEMALES, and MALES -- and he noticed when he switched from Excel 2003 to Excel 2007, because he doesn't get to go through the chart wizard, the default chart is giving him 3 series instead of 2.
There's the MALES, there's the FEMALES, but then, oh, there's the YEAR, and Richard actually wrote in because he had a nice little solution using data text to columns, choosing text, and then it would work, but I said, Richard, you're not going to believe this.
This is so arcane.
There's an even better solution, and you have to pull the solution out any time that the leftmost column is completely numeric or completely dates, which, of course, dates are numbers, and all you have to do is get rid of cell A1, even if you just do it temporarily, and choose that range, INSERT, LINE, LINE CHART, and look at that.
We get FEMALES and MALES and the YEARS are understood.
Of course, once you have the chart created, then you can come back up here and put your heading back like it should be.
All columns should have headings.
Just a bit of a hassle that you have to go through and remove that top left corner cell.
Again, any time that the leftmost column is completely numeric or dates, you'll want to do that.
Well, hey.
I want to thank Richard for sending that question in and I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
