pivot table series problems

  • Thread starter Thread starter bjackal831
  • Start date Start date
B

bjackal831

i'm making a pivot table and need to put two separate fields into th
series section, which is fine, except they overlap! All the data i
not one or the other, some is both. How can I make the pivot tabl
understand this. When I put the two sections into the series i
combines them to be different. One field should be Year to Date an
the other is Current. EVERYTHING (67) should be Year to Date, but onl
20 should be Current, b/c those are the projects just for this month.
I have two columns in the sheet, one has YTD all the way down all th
info, the other column just has current on those that are current. i
graphs "blank-ytd" and "current-ytd" so essentially it is graphin
current and everything else. It doesn't recognize that they overlap.
HELP
 
You need two fields, one for Current, and one for YTD. Or do I
misunderstand your problem?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete selection in pivotcolumn 3
Copy + paste macro 1
Wanted to show 12 month Date in Pivot table 2
Pivot Table Year to Date 2
Pivot Table Help 1
Alternative to pivot table ? 8
Subtotal percents in pivot table 1
How I can set dynamic pivot table ONLY when I have enough data point 1

Back
Top