logologo_light
CRM Support
  • CCC CRM
  • Inbound Marketing
  • Training
  • Resources
  • Blog
  • About
    • Greater Washington Business Roundtable and Other Events
  • Contact Us
  • CCC CRM
  • Inbound Marketing
  • Training
  • Resources
  • Blog
  • About
    • Greater Washington Business Roundtable and Other Events
  • Contact Us

Create Stunning Visual Data Charts with your Excel’s PivotTable and PivotChart

What do you do when the boss says “I have all this Excel data but I don’t know what it means”? Presenting your data in an organized way is critical to spot trends and to make projections.

We all know that visualizing data is the key to an effective presentation. There are many tools like Tableau that can visualize your data, but to do that means another investment in a new platform that we have to learn. What if we told you that you may not need a data visualization tool like Tableau to visualize your data? What if we told you that you can visualize your data with Excel?

Well, we are here to tell you that you can. Excel has a great feature called PivotTable that lets you summarize data in meaningful groups. It gives you control of your data so that you can make predictions and analyze trends. We wrote a blog that gives you a step-by-step tutorial on PivotTables. If you are unfamiliar with Pivot Tables, we suggest you take a moment and read through that tutorial.

PivotTables is just the icing on the cake. Excel also has a feature called PivotChart that gives you more control over the visualization of your data. Charts include statistical, line, pie, waterfall, among other chart types.

We are going to walk you through the basics of PivotChart.

 

Start by opening your Excel file that has the PivotTable. You can click on the Insert tab and select the PivotChart option.

When your PivotChart opens in the work area, you can choose the fields of your data that you would like to show in the chart.

The beautiful thing about PivotChart is that you are not restricted to one type of chart. Depending on the data, you can choose other chart types by going to the Design tab and selecting Change Chart Type. Here, you can select the chart that will make the most visual impact.

 

 

Now you can share your data visualization and help your viewers whether they be C-level executives, board members, or your sales team see a better picture of what you are trying to convey.

We know that understanding and using features in Excel like PivotTable and PivotChart is beneficial to your organization. It can help you organize your data, minimize confusion, and make informed decisions. This is why we offer customized online corporate training in Excel and other Office365 apps because we know it is important that your staff has the knowledge of the software and uses it productively and consistently. If you are interested in Excel training for your company, please contact us. We would love to talk to you.

Contact Us

More Excel and Training Topics

Look Like A Champ With MS Office 2016 (Part 2)

And we continue with great ideas! Better Chart Types – In Excel, we’ve always appreciated the ability to visualize data and looked at it as an effective, powerful tool. But it became obvious that users need much more. MS Office 2016 includes a set of highly anticipated new charts to give users more way to explore […]

Read more

Respond Faster and De-Clutter Your Inbox with Outlook Rules – Part Two

Recently, we shared how Microsoft Outlook makes it easy to manage emails and direct specific emails to specific folders enabling you to respond in a timely manner. Rules automate your emails based on criteria. If you missed our newsletter on creating new or custom Outlook rules, you can read it here. This week, learn how to […]

Read more
  • On October 20, 2020
Tags: Excel, Training
Recent Posts
  • Practical and Effective Ways to Use Your CRM in the Buyer’s Journey
  • Buyer’s Journey vs the Customer’s Journey. What’s the difference?
  • Do you know how people are interacting ON your website?
  • 4 Practical Ways to Make Online Networking More Effective
  • Show your Referrers the Appreciation that They Deserve
Tags
Analytics (1) Buyer's Journey (2) Case Study (1) CRM (57) CRM dashboard (1) CRM Implementation (8) Customer's Journey (1) Customer Relationship (1) database (1) Email (8) Excel (3) Follow Up Fatigue (6) Inbound Marketing (22) KPI (1) Marketing Automation (4) Marketing Campaign (16) Networking (1) Powerpoint (1) Referral Network (3) Sales (50) Sales Manager (5) security (1) SEO (2) Social Media (5) Training (20) User Experience (1) Video (4)
Contact Us
Contact Us

Generate New Qualified Leads Using Gated Content

Previous thumb

CRM Implementation: The Right Way to Do It

Next thumb
Scroll

5335 Wisconsin Avenue, NW
Suite 640
Washington, DC 20015

301-332-0613
info@cccsolutions.com

Sign up for our newsletter to receive software tutorials and tips on CRM and marketing strategies

@2020 CCC Solutions