1016 Redux - 1026 - Learn Excel from MrExcel Podcast

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jun 1, 2009 .
Mario sends in an UGLY solution to episode 1016. Episode 1026 will show you how to highlight one segment of a line chart in Excel 2003. This episode wins an award for the ugliest workaround.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Transcript of the video:
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Basically, we start out with massive amount of data.
How we're gonna analyze as well plus file up a pivot table.
See, how can we solve this problem.
Today, I have an award for the ugliest work around ever in the history of Excel.
Back in episode 1016.
I lamented about the fact that, we cannot highlight a segment of this line chart in Excel 2003, with the surface chart because it draws a diagonal line down to the zeros.
Excel 2007, doesn't do that But, I received a note from Mario.
Mario has been on the podcast before already has an Excel master, Ben and clearly we need to create a new pin for this.
He tells me right up front, the subject line and email.
This is an ugly ugly solution.
But, check it out this is Excel 2003 and it is only highlighting a segment of the line without the diagonals.
Amazing, isn't it?
Alright! Now, I noticed over here that we had columns D E F and G were very narrow.
So, I went in and said let's make these wider and then we can see the values that are there and sure enough the chart includes these extra values and if we would change the chart data back.
Just like my problem, It has the diagonal.
So, I'm going to undo that.
Here is the trick, let's take a look at these bit by bit by bit.
It is brilliant!
I choose series 3 and let me change the fill color of series 3.
So, you can see that those are two column charts that the background has been changed to match the Excel background.
Let's take a look at series 4.
Series 4 is another column chart will change the color of that to another color and it also has been changed to match the background.
That ensures that we don't get those tails appearing.
What the heck is series 5 and series 6, 4.
Oh!
Well, hey!
Very clever series 5 and series 6 our line charts.
That make sure that the line appears on top of series 3 and series 4 definitely just this is over the top as far as going to extremes in order to make sure that.
One, the grid lines reappear to those rogue corner set.
Because there's always someone who has some amazing way to do it.
Now, if I had to do this day, after day, after day.
I would probably just throw down the money to get Excel 2007 and deal with the Ribbon.
Very,, very cool way to go.
Hey! I want to thank you for stopping by, we'll see you next time for another netcast, from Mr. Excel.
Thank you for stopping by, we'll see you next time for another netcast, from MrExcel.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,812
Messages
5,833,803
Members
430,233
Latest member
cbutts

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back