Excel 2007:  Pivot Tables

Posted on 2011-04-28
Last Modified: 2012-05-11
Hi Experts,

   Trying to make chart that's tied into the below data table but am having issues.  Creating a pivot table for this simple chart has been somewhat of a challenge due to the blank cell that I've highlighted.  I'd like the final chart, if possible to look like what you see below.  Thanks GREATLY for your help!

Question by:itsmevic
    LVL 50

    Accepted Solution


    what are the issues? Just select the data table and build a regular column chart. Your data is already laid out for that. No need to create a pivot.

    cheers, teylyn

    Author Comment

    LOL...I'm such a dip$...,  total brain fart here...I was trying to make it totally harder than it was by going another route.  Sometimes the easy route is right before us and we never seem to notice it.  Thanks for your input teylyn.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now