Results 1 to 2 of 2

Simple invoice status monitoring dashboard based on pivot table

Threaded View

  1. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    19,040

    Re: Simple invoice status monitoring dashboard based on pivot table

    To put the months in the horizontal axis go to: Pivot Table Tools > select data > switch column/row (I don't believe that you can put the months in the horizontal axis without changing the pivot table).
    To show solid columns not divided by invoice number move invoice number from the column area to the filters area and leave set at all, or remove from field list entirely.
    To omit the invoice amount that was issued in September put issued in the Filters area of the field list and deselect Sept-21
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. monitoring / tracking system with a front dashboard
    By cyberice in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2020, 03:03 PM
  2. [SOLVED] VBA: Pull data based on time frame from Raw data or pivot table to dashboard sheet column
    By Sharonjit in forum Excel Programming / VBA / Macros
    Replies: 55
    Last Post: 12-20-2018, 10:00 AM
  3. Pivot Table Dashboard
    By vishnuuvm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-03-2016, 02:11 PM
  4. Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  5. Dashboard/pivot table
    By interested in forum Excel General
    Replies: 7
    Last Post: 02-08-2012, 03:31 PM
  6. MDB Pivot table to dashboard chart
    By GreenatExcel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-08-2007, 04:27 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