Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
In a compelling series of verite encounters, Win Win provides unique access into the minds and lives of the world’s most-celebrated entrepreneurs and athletes.
Explore what it means to be human as we rush head first into the future through the eyes, creativity, and mind of Tiffany Shlain, acclaimed filmmaker and speaker, founder of The Webby Awards, mother, constant pusher of boundaries and one of Newsweek’s “women shaping the 21st Century.”
Nicole Richie brings her unfiltered sense of humor and unique perspective to life in a new series based on her irreverent twitter feed. The show follows the outspoken celebrity as she shares her perspective on style, parenting, relationships and her journey to adulthood.
Comedy is hard, but teaching comedy to children is hilariously difficult. Kevin Nealon is giving the challenge to some world-famous comedians. As these young minds meet with comedy’s best, get ready to learn some valuable comedy lessons, and to laugh!
James Franco loves movies. He loves watching them, acting in them, directing them, and even writing them. And now, he’s going to take some of his favorite movie scenes from the most famous films of all time, and re-imagine them in ways that only James can.
The story of punk rock singer Laura Jane Grace of Against Me! who came out as a woman in 2012, and other members of the trans community whose experiences are woefully underrepresented and misunderstood in the media.
Executive produced by Zoe Saldana (who will be the subject of one episode), a celebrity travels back to their hometown to pay tribute to the one person from their past (before they were famous) who helped change their life by giving them an over-the-top, heart-felt surprise.
Enter the graceful but competitive world of ballet through the eyes of executive producer, Sarah Jessica Parker. This behind-the-scenes docudrama reveals what it takes to perform on the ultimate stage, the New York City Ballet. Catch NYCB on stage at Lincoln Center.
Park Bench is a new kind of "talking show" straight from the mind of born and bred New Yorker and host, Steve Buscemi.
Go behind the scenes with some of the biggest digital celebrities to see what life is like when the blogging and tweeting stops.
Digital influencer Justine Ezarik (iJustine) is back. After covering the world of wearable tech last season, iJustine is expanding her coverage this year by profiling the hottest tech trends across the country.
Documentary shorts conceived of and directed by famous actors. Jeff Garlin, Katie Holmes, Alia Shawkat, Judy Greer, and James Purefoy
A 12 episode documentary series following 5 startup companies competing in the 2013 San Francisco TechCrunch Disrupt Startup Battlefield as they fine tune their products and eventually present in front of a panel of judges in hopes of winning $50,000 in funding.
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.
Tags:How to Highlight a Segment of a Line Chart in Exce,Excel Lesson,excel spreadsheets tutorial,How to Highlight a Segment of a Line Chart in Exc,Learn Excel,MrExcel Podcast
Grab video code:
Hey. Welcome back to the MrExcel netcast. I’m Bill Jelen.
Basically, you start out with massive amounts of data and then how we’re going to analyze this. Well, let’s fire up the pivot table and see if we can 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 zeros. Excel 2007 doesn’t do that but I received a note from Mario.
Mario has been o the podcast before, already has an excel master pin and clearly we need to create a new pin for this. He tells me right up front the subject line in 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 where very narrow so I went in and said let’s make this lighter and then we can see the values that they 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 diagonals. So I’m going to undo that.
Here is the chart. Close take a look at these bit by bit by bit. It is brilliant. I choose series three. And let me change the fill color of series three 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 four. Series four is another column chart. We’ll 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 are series 5 and series 6 for? Well, hey, very clever. Series 5 and series 6 are line charts that make sure that the line appears on top of series 3 and series 4 definitely this is over the top as far as going to extremes and order to make sure that one, the grid lines re-appear, two, those rogue—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—a 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.
Well, thanks for stopping by. We’ll see you next time for another netcast from Mr. Excel.