+ Reply to Thread
Results 1 to 6 of 6

Missing an axis when creating pivot chart

  1. #1
    Registered User
    Join Date
    12-04-2015
    Location
    california
    MS-Off Ver
    2013
    Posts
    21

    Missing an axis when creating pivot chart

    I tried to create a pivot chart but the value is not being listed for each month. What did I do wrong?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Missing an axis when creating pivot chart

    you need to use another data system
    Attached Files Attached Files

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Missing an axis when creating pivot chart

    Stasinek, I know what you are doing. You don't need to explain it to ME.

    Can you please explain to the OP what steps are required to arrive at the result you are showing?

    This will help people to learn.

    cheer, teylyn

  4. #4
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Missing an axis when creating pivot chart

    sorry, already I improve
    https://youtu.be/b06zFGVFXZ8

  5. #5
    Registered User
    Join Date
    12-04-2015
    Location
    california
    MS-Off Ver
    2013
    Posts
    21

    Re: Missing an axis when creating pivot chart

    I see what stasinek did by reversing the rows and columns so that the category is a column and date is a row. But why can't you create the chart with the original format where category is a row and date is a column?

  6. #6
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Missing an axis when creating pivot chart

    You can, of course - click on the graph - the tab "Design" - switch row / column.
    I do not know whether I have translated - I use google translator

+ 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. negative y axis on pivot chart but axis doesn't change
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 06-24-2015, 02:19 PM
  2. Text is missing along the vertical axis of the chart (Y label).
    By Falkkortin in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-10-2006, 01:53 PM
  3. Missing x-axis labels on chart in XL97
    By Rob Hick in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-18-2005, 01:45 PM
  4. Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis
    By mw210461@yahoo.com in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-13-2005, 05:05 PM
  5. missing three letters of y axis title of chart in excel
    By Julie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-13-2005, 07:06 PM
  6. [SOLVED] Missing lines in chart w/x-axis with months 1-24...
    By DendWrite in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-10-2005, 05:06 PM
  7. Creating Pivot Chart with 2 Y axis
    By silks in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-17-2005, 08:32 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