Skip to content

TechRepublic

  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • TechRepublic Premium
  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Software

Image: Create advanced graphs and PivotCharts with Excel

By Bill Detwiler January 18, 2006, 2:52 AM PST on Twitter billdetwiler

Image
1
of 17

5041.jpg
5041.jpg
Image: Create advanced graphs and PivotCharts with Excel

Scott Lowe

A fairly typical data set provides a good place to demonstrate Excel’s graphing abilities.

Scott Lowe
Image: Create advanced graphs and PivotCharts with Excel

With a graph, the type of diagram you select is critical when it comes to getting your point across. For example, if you wanted to diagrammatically show how much of your monthly payment went toward rent, you would probably not use a line graph. Instead, a pie chart would be more appropriate since it shows you slices of a whole.
rnThe 3-D bar is a sub-type of a normal bar chart.

Image: Create advanced graphs and PivotCharts with Excel

The second step of the wizard asks you to select your data range and to determine whether data is separated by columns or rows. For this example, I didn’t need to select a range. The data range matches my selection, and I want the “Rows” data series.

Image: Create advanced graphs and PivotCharts with Excel

This step provides fields for better explanation of what’s on your graph.

Image: Create advanced graphs and PivotCharts with Excel

This graph isn’t perfect. It’s the right kind of graph, but the data isn’t really the best for this kind of comparison. This isn’t the best view of the data, but there’s a good reason.

Image: Create advanced graphs and PivotCharts with Excel

With the removal of two unnecessary series, the graph looks quite a bit different. This still isn’t the best graph, but you’ll quickly notice that the differences from month-to-month are much more pronounced now. This is largely because the scale now tops out at $250 rather than $1,000.

Image: Create advanced graphs and PivotCharts with Excel

Hold your mouse over one of the bars in the graph. A tool tip appears providing you with information about that data point. The tool tip provides with you all of the information related to the bar.

Image: Create advanced graphs and PivotCharts with Excel

Excel gives you the ability to rotate a 3-D graph any way you like. To do so, you need to click somewhere on the graph “wall” after which you can manipulate the graph. The corner control is key to graph rotation capability.

Image: Create advanced graphs and PivotCharts with Excel

It’s a little hard to see in this shot, but that is the plus icon control. Now, while holding down the left mouse button, drag one of the corner controls around the screen. Notice that your graph rotates as you move the controls. While you are dragging it around the screen, your graph appears to be a wire frame instead.

Image: Create advanced graphs and PivotCharts with Excel

The wire frame helps to conserve computing resources. It takes a lot of processing power to redraw the graph while you move it. When you’re done dragging, your graph looks completely different, and you can get different views on the data.

Image: Create advanced graphs and PivotCharts with Excel

The budget spreadsheet is a fairly typical layout and provides a good example. Just like with a PivotTable, a PivotChart is started by placing your cursor somewhere inside your data table and choosing Data | PivotTable and PivotChart Report from the menu.

Image: Create advanced graphs and PivotCharts with Excel

This is where things change a bit. Under “What kind of report do you want to create”, instead of selecting PivotTable, select the “PivotChart report” option. This will give you a blank chart to start with.

Image: Create advanced graphs and PivotCharts with Excel

Here’s a look at your drawing board. You might notice that this looks a lot like a blank PivotTable sheet and, like that sheet, this one has various places to which you drag fields to design your report any way you like.

Image: Create advanced graphs and PivotCharts with Excel

As an example, I’ll do the following:

    rn

  • Place the Month field into the “Category” area.
  • rn

  • Place the Department field into the “Series” area.
  • rn

  • Place the Amount field into the “Data Items” area.
  • rn

rnWith three clicks and drags, I was able to whip up this chart.

Image: Create advanced graphs and PivotCharts with Excel

Just like with a normal chart, you can make all kinds of modifications to your PivotChart. Just about everything available with a normal chart is available here. Change any option you like!

Image: Create advanced graphs and PivotCharts with Excel

One of the first things you might want to do is use a different type of chart. After all, a bar graph isn’t always the best option. To change your graph type, from either the PivotTable toolbar or the standard toolbar, click the Chart Wizard button. You can change the PivotChart to any kind of chart you like.

Image: Create advanced graphs and PivotCharts with Excel

For this example, I’ll change the chart type to a 3-D pie chart. I’ve also moved the Department field to the Category slot, and removed the Month field completely. Why did I remove the month field? A pie chart can’t break down both a category and a series at the same time. By leaving the month field, the pie chart was being based on just the first month’s worth of data. By removing the field, I was able to get a pie chart that accurately reflected the total of each category for all months. Here’s a down-and-dirty pie chart.

  • Software
  • Account Information

    Share with Your Friends

    Image: Create advanced graphs and PivotCharts with Excel

    Your email has been sent

Share: Image: Create advanced graphs and PivotCharts with Excel
Image of Bill Detwiler
By Bill Detwiler
Bill Detwiler is the Editor for Technical Content and Ecosystem at Celonis. He is the former Editor in Chief of TechRepublic and previous host of TechRepublic's Dynamic Developer podcast and Cracking Open, CNET and TechRepublic's popular online show.
  • Account Information

    Contact Bill Detwiler

    Your message has been sent

  • |
  • See all of Bill's content

Daily Tech Insider

If you can only read one tech story a day, this is it.

TechRepublic Premium

  • TechRepublic Premium

    Quality Assurance Checklist For Outsourced Projects

    Quality assurance refers to the processes being used to manage the project and to build the deliverables. This is in contrast to quality control, which refers to the activities used to create the deliverables. Because you are not responsible for the creation of the deliverables (quality control), you need to be comfortable that the outsourcer ...

    Provided By TechRepublic Premium Published:  Nov 2023 Modified:  Nov 2023 Read More
    Download Now
  • TechRepublic Premium

    Cloud Computing Policy

    The list of advantages to cloud computing include lowered operational costs, greater technological flexibility and the ability to rapidly implement new systems or services. Gains in business continuity are an especially noteworthy attraction to cloud services, which operate via remote systems that remain running in the event of a local disaster, such as a hurricane ...

    Provided By TechRepublic Premium Published:  Nov 2023 Modified:  Nov 2023 Read More
    Download Now
  • TechRepublic Premium

    Quick Glossary: Business Intelligence and Analytics

    Business intelligence and data analytics give tech decision makers a clearer idea of how well their companies are running and whether they’re meeting goals. Because BI incorporates data from across the enterprise — revenue operations, sales, supply chain and logistics — its insight is beneficial in areas such as customer profiling, customer support and market ...

    Provided By TechRepublic Premium Published:  Nov 2023 Modified:  Nov 2023 Read More
    Download Now
  • TechRepublic Premium

    Hiring Kit: Video Game Producer

    Even for the smallest and most independent developers, creating a successful modern video game requires the coordination of designers, programmers, testers, artists, musicians, animators and a multitude of other talented personnel. Getting all these moving parts to work together, synchronize their production and do it on time and on budget is the role of the ...

    Provided By TechRepublic Premium Published:  Nov 2023 Modified:  Nov 2023 Read More
    Download Now

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • Editorial Policy
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice
CLOSE

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

Already registered? Sign In
Use Facebook
Use Linkedin

* - indicates required fields

CLOSE

Sign in to TechRepublic

Not a member? Create an account
Use Facebook
Use Linkedin

Lost your password? Request a new password

CLOSE

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support.

Back to login
1 Finish Profile
2 Newsletter Preferences
CLOSE

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

No thanks, continue without
1 Finish Profile
2 Newsletter Preferences
CLOSE

Want to receive more TechRepublic news?

Newsletter Name
Subscribe
Daily Tech Insider
Daily Tech Insider AU
TechRepublic UK
TechRepublic News and Special Offers
TechRepublic News and Special Offers International
Executive Briefing
Innovation Insider
Project Management Insider
Microsoft Weekly
Cloud Insider
Data Insider
Developer Insider
TechRepublic Premium
Apple Weekly
Cybersecurity Insider
Google Weekly
Toggle All
No thanks, continue without

You're All Set

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add newsletters@nl.technologyadvice.com to your contacts list.

Back to Home Page