locked
My powerpivot window, home tab, view area, does not have a diagram view. How do I find it? RRS feed

  • Question

  • I am following the tutorial for powerpivot tables from the microsoft SQL server site.  In the section for creating relationships, it references a diagram view located on the powerpivot window, home tabe, view area.  I do not have this option on my ribbon.  Is there a way to add it in?
    Friday, September 7, 2012 4:25 PM

Answers

  • Have you tried opening any existing Power Pivot excel, even I had the same problem, however when i open any existing Power Pivot excel it automatically shows the Diagram view and others.

    Nanda

    Wednesday, July 10, 2013 12:14 AM

All replies

  • What version of PowerPivot are you using? Diagram view is not in PowerPivot v1.


    -- This posting is provided "AS IS" with no warranties, and confers no rights

    Friday, September 7, 2012 11:42 PM
  • There are more details on Diagram View on the Link

    http://technet.microsoft.com/en-us/library/hh272047.aspx

    Manjunath RV

    Saturday, September 8, 2012 11:17 AM
  • Hi ltlnt,

    As Chu posted above, PowerPivot Version 1 doesn't not have Diagram View which has been introduced in PowerPivot Version 2. In addition, please ensure that you install SQL Server PowerPivot V2 for Excel successfully. So, we can click the "PowerPivot" tab when you open a Excel workbook. For more information about installing PowerPivot for Excel, please refer to the article below:
    PowerPivot for Excel Installation: http://technet.microsoft.com/en-us/library/ee210599.aspx
    http://blogs.msdn.com/b/analysisservices/archive/2011/07/20/the-diagram-is-here.aspx

    Regards,
    Bin Long


    Bin Long

    TechNet Community Support



    • Edited by Elvis Long Monday, September 10, 2012 5:40 AM
    Monday, September 10, 2012 5:30 AM
  • I downloaded the 32bit R2 version for Office 2010.  Got half way through the tutorial with no problems.  Just no diagram view.  Removed the download, then reinstalled. Got tab for power pivot as before, clicked on PowerPivotWindow, view area still does not have a diagram view.
    Tuesday, September 11, 2012 7:22 PM
  • I'm facing the same issues on a 2010 Excel running on a Windows 7.

    Installed the latest PPivot from Microsoft website. Also installed .NET4 and Visual Studio 2010 Tools for Office Runtime as recommended.

    Updated/downloaded the lastest updates suggested by Win Update 

    Etc etc

    But the problem remains : no diagram view and none of the latest additions to PPivot.

    ANyone got an idea ?

    Wednesday, July 3, 2013 7:27 AM
  • Have you tried opening any existing Power Pivot excel, even I had the same problem, however when i open any existing Power Pivot excel it automatically shows the Diagram view and others.

    Nanda

    Wednesday, July 10, 2013 12:14 AM