Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity. We'll hear their inspiring stories firsthand, whether fighting back from a career-ending injury or transforming their lives and bodies through diet and exercise.
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.
The Future Of Us is a powerful original series from television personality, futurist, filmmaker and techno-philosopher, Jason Silva. In this series, Silva shares his excitement around recent discoveries and inventions.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
They say every picture tells a story and AOL On's new original series My Ink proves it. Travel along as some of the world's greatest athletes bring their tattoos to life through exclusive interviews and visits to their favorite tattoo parlors.
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.”
Discover crowdfunded small business success stories with author, comedian, and entrepreneur Baratunde Thurston.
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
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.
Iconic potter, designer, author and personality Jonathan Adler shares his unique perspective on creativity. Showcasing the inspiration Jonathan finds in the most unlikely people and places, Inspiration Point will add style, craft and joy to your life.
Serving Innovation gives a fresh look into the stories and passions that motivate some of the most innovative tastemakers in America.
A documentary directed by Alex Winter exploring the Napster downloading revolution; the kids who created it, the bands and businesses that were affected and its impact on the world at large.
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.
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.