+ Reply to Thread
Results 1 to 2 of 2

pivot table chart that shows #of days

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    City, World
    MS-Off Ver
    Office 365
    Posts
    248

    pivot table chart that shows #of days

    Hi
    I created the attached file long time ago and of course with some help from your people, I managed to do it. Now I want to do the same thing but i forgot how I had done it. I totally managed to remove the second data series and kept only "#of days" series. How can that be done. Also how can I know what type of chart is that? anywhere in the ribbon can tell me what type of chat? Thank you so much.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-17-2020
    Location
    Bangkok, Thailand
    MS-Off Ver
    365
    Posts
    17

    Re: pivot table chart that shows #of days

    It is Stacked Bar Chart.
    Hide the 1st series by set No Fill and No Line.
    You can find the guide by searching "Excel Gantt Chart".
    Visit my YouTube channel Excel NaNa

+ 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. [SOLVED] Pivot table and chart all value shows in Sept
    By chaiyya345 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-23-2020, 10:41 PM
  2. Replies: 1
    Last Post: 10-16-2019, 01:23 PM
  3. Pivot Chart shows date format as number
    By promo_dobbu in forum Office 365
    Replies: 1
    Last Post: 10-10-2019, 10:21 PM
  4. [SOLVED] Pivot Table shows same month twice!
    By Erik199 in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 06-07-2018, 07:16 AM
  5. [SOLVED] Creating a Dynamic Chart that shows from Today for 100 days forward, changing daily
    By Robbie8 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-26-2016, 08:13 PM
  6. Pivot Chart that shows average number between dates.
    By B_Jarbs in forum Excel General
    Replies: 3
    Last Post: 02-07-2016, 11:09 AM
  7. [SOLVED] Pivot Chart which shows average line with below and above figures
    By Env shah in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-03-2006, 06:55 AM

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