Display pivot table data and corresponding graph from same worksheet in excel on Excel Services web part - Graph not showing RRS feed

  • Question

  • Pivot table data is located on Worksheet 1; Have created a pivot chart on same worksheet right beside the data; Have created a named range encompassing both data and chart and named it COMBINE; Have included COMBINE on my named item on my excel services web part. Sharepoint only shows the data and not the graph? How can I get the graph to show?

    I did see a blog from Tezler saying the following:
    The graphs appear to float above the sheet, therefore aren't true cell content. As soon as any cell in the range has content the named item is available to publish!

    I did put content in the cells that the graph sits on top of. Still doesn't work. Any ideas?

    Friday, March 18, 2011 6:15 PM

All replies