+ Reply to Thread
Results 1 to 3 of 3

Y axis actual values representation

  1. #1
    Registered User
    Join Date
    10-21-2019
    Location
    Berlin
    MS-Off Ver
    2003
    Posts
    1

    Y axis actual values representation

    Hello,

    Can you help me please with the following chart? How can I make it represent on Y axis the actual values from Value 1 and Value 2 columns and not those generic 500, 1000, 1500, 2000?

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Y axis actual values representation

    Hi and welcome
    your profile indicates you are using XL2003. Is this the case?

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

    Re: Y axis actual values representation

    You will need to add a dummy series, plotted as an xy-scatter, in order to draw those axis values yourself.
    Attached Files Attached Files
    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)

Similar Threads

  1. Replies: 2
    Last Post: 06-22-2017, 06:16 PM
  2. [SOLVED] Trying to set chart axis by actual data it is sorting through
    By bdouglas1011 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 09-05-2014, 11:57 AM
  3. [SOLVED] Chart with X Axis Showing Actual Passage of Time
    By pcook911 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-02-2013, 01:12 AM
  4. X-axis and label with dates of actual samples
    By sonora in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-08-2011, 02:12 PM
  5. Excel chart. Displaying y axis numbers different to actual plot values.
    By Richard Buttrey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2011, 12:40 PM
  6. chart scale from actual Y axis data
    By robert111 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-12-2008, 09:41 AM
  7. [SOLVED] Automatic representation of cell values
    By Venkatesh V in forum Excel General
    Replies: 2
    Last Post: 03-21-2006, 11:45 PM

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