Excel 2007:  Pivot Tables

Posted on 2011-04-28
Medium Priority
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

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 35487589

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

ID: 35488796
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

621 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