I've got a decent PowerPivot sheet started. I've got a few issues though.
1. I started by creating a sheet with a PivotTable over a PivotChart, one the coices in the report section of the PowerPivot tab. This worked great so I another chart and another table. I got them all to link to the slicers without much
issue. However the newly added charts don't show anything selected as being attatched to these slicers in the PowerPivot Field List. Not a big issue for me as the developer, but this product is meant to be passed onto users and this just won't
2. Sparklines. These are great. I can add them nicely right next to my PivotTables. The issue is if the table moves, the SparkLines don't really belong to it so they stay behind if the table moves. If I add more rows to the
table by making slicer changes, no new SparkLines. How do I integrate these more tightly with the table so I can move the table and keep the SparkLine with it? How do I get it to create more SparkLines as the data grows?
3. A continuation of this. Since the table is over the chart. If I add more lines of data to the table through Slicer changes the extra lines can end up hidden behind the chart. I need the table to have properties like can grow that
will push the chart lower in the Excel sheet and also pull them back up if the data is reduced. Is this possible?
4. Sparklines and direction. I have one Sparkline created that is based off of ranks. The data numbers show up fine. The Sparklines however are drawn wrong because normally 1 is lower than 2. For ranks of course 1 is best and
I want that to be the higher point in the Sparkline. How do I do this?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.