+ Reply to Thread
Results 1 to 8 of 8

PivotTable and Pivot Chart and Dashboard

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    Houston, TX, USA
    MS-Off Ver
    Excel 2016
    Posts
    58

    PivotTable and Pivot Chart and Dashboard

    My PivotTable and my PivotChart are showing in opposite order. I want the Chart to match the Table (Installation at top). I know that there is a simple way to correct this, but I can't remember. Please help.

    Also I need a dashboard for these 3 PivotCharts. Please do the dashboard, add slicers for Location, Category and Condition. Please add a Word file with step-by-step easy-to-follow instructions. I will even pay, if I can figure out how to use that feature. Thank you!!!!!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by phillyfilly; 05-28-2017 at 03:30 PM. Reason: add worksheet

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    684

    Re: PivotTable and Pivot Chart and Dashboard

    In order to reverse the axis, please click on the axis, format axis and check the reverse order.

    Coming to the dashboard and slicers:

    1. Cut and past all the charts in to the new sheet "Dashboard"
    2. Hide all the field buttons on the chart (optional)- for a better look.
    3. Select any of the chart in the dashboard, In the analyse tab, select the condition, location and category.
    4. Place it properly.
    5. Select any of the slicer and in the "Options" tab, click on the "Report Connections"- select all the pivot table.
    6. Do the above step for the other 2 slicers.
    7. Now all the charts are connected with the slicers.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    684

    Re: PivotTable and Pivot Chart and Dashboard

    Press Ctrl Button and select each chart. In the Format Tab, change the sizes: for e.g. Height 3" and Width 5".
    Please close the thread if you think we have provided the right answer.

  4. #4
    Registered User
    Join Date
    12-07-2012
    Location
    Houston, TX, USA
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: PivotTable and Pivot Chart and Dashboard

    TO: Shareez Saleem

    I found Categories in Reverse Order, but I hit something along the way. Now all my categories total 700K and the axis is at the top. I want the axis to go from zero to 100K to 700K, because it was too crowded. And I want the axis at the bottom, not the top.

    I have attached a new screenshot, and a new data file (Dashboard02).

    Please tell me what two things I did wrong, to change bars and to change axis. Thank you very much.
    Attached Images Attached Images
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    684

    Re: PivotTable and Pivot Chart and Dashboard

    Click on the Axis > Format Axis > Axis Options > Change the minimum (to 0.0) > Change the Maximum (to 800000).

  6. #6
    Registered User
    Join Date
    12-07-2012
    Location
    Houston, TX, USA
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: PivotTable and Pivot Chart and Dashboard

    TO: Saleem Shareez

    In another tutorial video I saw a way to show all your charts on the screen at the same time. They used Ctrl+Page Down or Shift+Page Down, but it did not work for me. Which is correct?

    I have two more questions and then I can close this thread. I posted a new screenshot (all bars at 700), and a new data file (Dashboard02). I want to know what I did wrong, and how to correct it. I want all bars in increments of 100K. Thanks.

  7. #7
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    684

    Re: PivotTable and Pivot Chart and Dashboard

    Please review the charts which i have sent you earlier. Right click on each area and see the selections made.

    For a better look, change the axis as shown below- Axis option > Number > Custom > Format Code : #,##0,k > Add. Instead of 1000, it will show 1k, for 100000 it will show 100k and so on.

    Time to sleep, its 1 am here...bye.

  8. #8
    Registered User
    Join Date
    12-07-2012
    Location
    Houston, TX, USA
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: PivotTable and Pivot Chart and Dashboard

    TO: Shareez Saleem

    Thanks very much!!! You do excellent work. The system won't let me give you any more reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create a normal chart from PivotTable
    By John99 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-07-2009, 10:18 AM
  2. PivotTable Pivot Fields CurrentPage
    By lcdmjnd@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2008, 02:26 AM
  3. [SOLVED] PivotTable and Chart
    By Michael in forum Excel General
    Replies: 0
    Last Post: 08-03-2006, 02:00 PM
  4. Excel 2007 PivotTable and Chart
    By Michael in forum Excel General
    Replies: 0
    Last Post: 06-27-2006, 04:35 PM
  5. [SOLVED] XY-chart with pivottable?
    By SvenM in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 08:17 AM
  6. [SOLVED] Date gaps in chart after pivotTable
    By David T. in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-14-2006, 01:15 PM
  7. Grouping dates in PivotTable/Chart
    By Heidi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-24-2006, 09:30 PM
  8. How do I add new data to a pivottable/chart?
    By Brian Lee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-04-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1