1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

additional info on existing chart

Discussion in 'Discuss Data Visualizations and Charting' started by Raghavendra Singh, Mar 7, 2018.

  1. Raghavendra Singh

    Raghavendra Singh New Member

    Messages:
    10
    Helo Everyone,

    From table-2 --- I want to show average billing and hours need to bill on upper right hand side of this existing chart and want them changing with the slicer which is already there.

    Please help ASAP.

    Thnk you,
    Raghavendra

    Attached Files:

  2. Raghavendra Singh

    Raghavendra Singh New Member

    Messages:
    10
    Hello Everyone,

    Please review and reply. Help will be appreciated.

    Thank you,
    Raghavendra
  3. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    777
    Hi, your file contains a link or links to external files. On enable content, all values are replaced by errors (N/A). Difficult to help you out that way. Might be the reason why no-one reacted.

    I detect perhaps this issue with the request: current chart is based on pivot. You cannot add a data series from another table.
    One table is with user names, the other is not. The chart uses user names (x-axis). So how do envision the chart you are after? Common are the dates, not the user names. What would it show?

    At first glance I doubt the actual data lay-out allows you to do what you are after. But I can be wrong obviously.
    Perhaps you can make a new table, holding the dates, user names and some lookups to fetch the required values.
    Make a chart on this table. And use a slicer on the table (possible in XL 13 and later). Table reacts on slicer, chart reacts on table thus chart reacts on slicer...
    Isn't that what you are after?
  4. Raghavendra Singh

    Raghavendra Singh New Member

    Messages:
    10
    Hello Everyone,

    I have updated the file again after making the corrections.

    Thank you,
    Raghavendra

    Attached Files:

  5. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    777
    Can you also share the version of your Excel?
  6. Raghavendra Singh

    Raghavendra Singh New Member

    Messages:
    10
  7. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    777
    perhaps this?
    I added a lookup in table 1 to fetch the missing value from table 2; made a new pivot and a new chart on sheet3.
    upload_2018-3-8_18-1-13.png

    Attached Files:

    Dillina likes this.
  8. Raghavendra Singh

    Raghavendra Singh New Member

    Messages:
    10
    Thank you for your response. I don't want to make average billing and hours need to bill to be part of this chart i just want their numbers on right hand corner.
  9. Raghavendra Singh

    Raghavendra Singh New Member

    Messages:
    10
    and those numbers should change when slicer selection changes
  10. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    777
    Oh, wait... like so... I just added them to give you the idea on how it an be accomplished.

    Attached Files:

    Dillina likes this.
  11. Alex Bitman

    Alex Bitman New Member

    Messages:
    1

Share This Page