Hey all & thanks for trying,
2 Issues on one post.
So I have a traditional pivot table going out by months, in the outter months I do not yet have data. This makes the graph sink like illustrated in those outter months. I tried formatting the data, IFs to return values other than o in the data but the table still treats that as 0. I tried formating the table to treat the 0 as blanks but the chart still treats this as zero. The data is too extensive to create a rule on what to pivot. Is there a chart feature that simply doesn't plot anything with a 0 in a line graph?
Two. Is there a way in my pivot, without having to reaarange my data, to create a drop down selection for my months as shown while keeping the structure of the pivot.
Thanks people, I've read like ninety blogs over the day looking for the right direction here.
LS
Bookmarks