+ Reply to Thread
Results 1 to 9 of 9

Help: Change data in table in graph

  1. #1
    Registered User
    Join Date
    08-24-2014
    Location
    banjaluka, Bosnia and Herzegovina
    MS-Off Ver
    2010
    Posts
    5

    Help: Change data in table in graph

    See photo:
    Untitled.png

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Help: Change data in table in graph

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Help: Change data in table in graph

    It's a lovely picture, but it and your extremely brief post, tell us NOTHING about what you actually want to achieve.
    Perhaps you could expand? And whilst you're at it, perhaps you could post a sample workbook?

    BSB.

  4. #4
    Registered User
    Join Date
    08-24-2014
    Location
    banjaluka, Bosnia and Herzegovina
    MS-Off Ver
    2010
    Posts
    5

    Re: Help: Change data in table in graph

    I hope i managed to attach workbook. I just dont know how to put English abbreviations for months into table beneath graph instead of those on my language.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-24-2014
    Location
    banjaluka, Bosnia and Herzegovina
    MS-Off Ver
    2010
    Posts
    5

    Re: Help: Change data in table in graph

    Anybody?????

  6. #6
    Registered User
    Join Date
    08-24-2014
    Location
    banjaluka, Bosnia and Herzegovina
    MS-Off Ver
    2010
    Posts
    5

    Re: Help: Change data in table in graph

    Dont know if you are aware but i have posted the workbook.

  7. #7
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Help: Change data in table in graph

    The range for the X-axis labels on your chart is still referring to another sheet where the months are listed in your language rather than in English.

    In the attached I have altered the range to that on a sheet where they are in English.

    Hope that helps.

    BSB.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    08-24-2014
    Location
    banjaluka, Bosnia and Herzegovina
    MS-Off Ver
    2010
    Posts
    5

    Re: Help: Change data in table in graph

    Thank you, solved it...

  9. #9
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Help: Change data in table in graph

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. How to change Graph Data Label
    By chriseverclear in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-28-2013, 04:11 PM
  2. [SOLVED] Dragging graph-points to change data? (!)
    By rememberkindness in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2006, 09:00 PM
  3. Dragging graph-points to change data? (!)
    By rememberkindness in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-24-2006, 09:00 PM
  4. Dragging graph-points to change data? (!)
    By rememberkindness in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2006, 07:15 PM
  5. [SOLVED] how do I change the data series an an excel graph
    By Deb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2005, 12:06 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