display data points in a pivot chart (excel power pivot) RRS feed

  • Question

  • Hi1! I have a question, when I put de mouse over a serie (a line in a line with markers chart) i can see in the box only de name of the serie... but in a normal pivot chart of excel I can se Sieres name, point and the exact value. How can I see this information when I put the mouse over a siere????
    Friday, December 30, 2011 11:19 PM


  • Hi bkeith11,

    In the Chart of PowerPivot, we have server Chart Layouts, not all the Layouts will should all the information you mentioned, such as: Series name, point and the exact value. But you can choose the right chart layout to show all the information (Series name, point and the exact value).

    Steps are:

    1. Click the whole chart, then you will see Design menu.

    2. Click the Design menu, Chart Layouts will show up.

    3. There are 12 kinds of Layouts, you can choose the right one to show all the tooltip informations.

    Challen Fu

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Challen Fu Thursday, January 5, 2012 10:02 AM
    Monday, January 2, 2012 6:44 AM