I then updated the pivottable to include values for both count of types and sum of the "unique" column for total records. Thank Jon, I was thinking I'd have to go that way! In the end I created a sub for my macro to add another column to the raw data sheet to indicate unique entries using if & countifs ( Unique Count in Excel Pivot Table With PowerPivot). So my series on the column graph would show the percentage of socks of each colour by month (from sheet 1), but my trendline needs to reference sheet 2 and display that there were two records in January (1 & 2) and two in February (3 & 4). Sheet 2 however removes duplicates and would only show total records, e.g. Sheet 1 would show all records with individual lines for type as above. ![]() If I use a pivotchart it will update when new data is added however I can't seem to be able to include data from two different pivottables on one chart. If I use a normal graph to include the series from both pivottables manually it won't expand when new months are added to the pivottable. ![]() (When exporting, our database creates a separate line for each type identified within a single record.) I need a stacked column graph to show the proportions of each type, but I need a trendline on the same graph showing total records. ![]() I have a workbook which has two data sheets-one for raw data for each month and one with the data with duplicate records removed. I also have this problem but with excel 2007.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |