Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Go behind the scenes with some of the biggest digital celebrities to see what life is like when the blogging and tweeting stops.
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.
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.
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.
Learn how to use Pivot Charts in MS Excel 2007 in this easy to follow step by step tutorial.
Tags:excel advance training,microsoft excel 2007,microsoft windows,pivot charts,pivot table,total training
Grab video code:
So far in this lesson, we have always talked about pivot tables. Pivot tables are a very powerful feature and for a few features of Excel, we had a pivot chart. A pivot chart in Excel 2003 though was really kind of clunky. They did not work very well. Let me show how they have improved in Excel 2007. Once we have a pivot table, we can convert it to pivot chart simply by clicking the pivot chart icon in the options ribbon. We can choose what type of chart we would like to see. I am going to choose the stacked column chart, the second thumbnail in the insert chart dialog. Click okay and Excel draws a default pivot table.
We have dates going along the bottom and then you could see the defects that popped up on the 28th, 29th and 30th of the month. This is a great visual view that the red line, line number two started having problems earlier than the other lines. But eventually on the last day of the month, you could see the purple and green become substantial. Now, what is fascinating about the pivot table is that we can change the value in the report filter. If I click the filter button at the right hand side of the report filter dropdown, I can show all, click okay. There is the analysis of all of our defects or I could choose any other specific defect. For example, air-conditioning failure, you will see that these were relatively constant throughout the month but there was something around the 20th or the 21st where those numbers spiked up.
The pivot chart filter pink can tend to get in the way, feel free to drag that out of the way so you could see the entire pivot chart. If you would like to change the pivot chart to a different type of chart, for example, a line chart or an area chart. That is easy to do using the change chart type icon in the ribbon. I will use a stacked area chart, click okay and then we have a completely different view of our data. Of course, all of the charting formatting options that we will discuss in another lesson are available here in pivot charts. Well, pivot charts were fairly hard to use in old version of Excel. Check them out in Excel 2007. They have come a long way and are very, very useful.