Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
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.
Documentary shorts conceived of and directed by famous actors. Jeff Garlin, Katie Holmes, Alia Shawkat, Judy Greer, and James Purefoy
Park Bench is a new kind of "talking show" straight from the mind of born and bred New Yorker and host, Steve Buscemi.
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.
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.
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.
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.”
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity.
Hank Azaria’s touching, humorous, and often enlightening journey from a man who is not even sure he wants to have kids, to a father going through the joys, trials and tribulations of being a dad.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
Follow Scott Schuman, the Sartorialist, from the streets of NYC to the capitals of Europe on his quest to photograph and document the best in culture and fashion.
Go behind-the-scenes with racing's hottest, young talent, 17-year-old Dylan Kwasniewski, as he aspires to make it in the #1 motorsport in America – NASCAR
In Episode 1038 - a better way to create the multiple scatter charts from Episode 1031 and 1032. Thanks to everyone who wrote ...
in with this better way to set up the data.
Tags:How to Create Multiple Scatter Excel Charts,Multiple Scatter Excel Charts,charting,charts,excel,MrExcel,spreadsheets
Grab video code:
Hey, welcome back to the Mr. Excel net cast, I’m Bill Jelen, amazing! We start out with massive amounts of data and how we’re going to analyze this. Well, let’s—and see if we can solve this problem.
Hey, welcome back to the Mr. Excel net cast, I’m Bill Jelen. Wow, I really screwed up back in episode 1031 and 1032 talking about how to create that X, Y chart with multiple series. I created it with a single series and then kept adding a new data, it turns out that you don’t have to do that at all and several people wrote in with the solution to this.
Basically, you set up your data like this with X1 and Y1 here like I had done but then below that, put the X2 values and the Y2 values over in column C. X3 values back in column A and then the Y3 values over in column D and so on down the way. And then when we create a XY from that whole big set, we get all of the XY points correctly in the right spots and you just have to go through and format them as I did back in episode 1032. So, thanks to everyone for sending those in. I’ll be spending a lot of money on postage for sending Excel master pins out there. That’s the great thing about excel. You can think that you know almost everything and you can always be surprised and I'm constantly surprised on these pod castings for that great tip, a great way to solve that problem. I appreciate all the folks who wrote in. watch your mail box for your excel master pins for that one. For everyone else, thanks for stopping by. We’ll see you next time for another net cast from Mr. Excel.