+ Reply to Thread
Results 1 to 2 of 2

pivot chart problem

  1. #1
    Registered User
    Join Date
    03-24-2013
    Location
    Texas, U.S.
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question pivot chart problem

    hello,

    i constructed a graph based on a pivot table.
    the data will be updated weekly.
    the elements in the graph are calculated by formula after new data is pasted.
    this week when the graph came out, it looked like the attached file, where the value of the two dots were clearly seen as below 10%, but on the graph it was plotted incorrectly on the Y axis.
    i'm not sure if this is a scaling issue, or if some kind of set up issue i am not aware of.
    any input would be appreciated.
    thank you!!
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: pivot chart problem

    I get that output when using 100% Stacked Line. I doubt this is the chart style you meant to use.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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