+ Reply to Thread
Results 1 to 3 of 3

Greatly Appreciated: Help with Scaling

Hybrid View

  1. #1
    Registered User
    Join Date
    09-12-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Greatly Appreciated: Help with Scaling

    Hello!

    If someone could direct me in how to scale my graph, that'd be fantastic!!

    \1

    What I would like is to make the X-Axis Scaling go in increments of 5 instead of the odd 0-2-5-10-30 spacing (know what I mean)?
    How would I be able to express that?

    Oh and ONE more thing! How do I make the graph so the beginning of the line graph (@zero) touches the y-axis?

    All help is appreciated. Thank you very much
    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,482

    Re: Greatly Appreciated: Help with Scaling

    use a scatter rather than line chart. Currently your horizontal axis is categorical rather than numeric
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Greatly Appreciated: Help with Scaling

    Quote Originally Posted by Andy Pope View Post
    use a scatter rather than line chart. Currently your horizontal axis is categorical rather than numeric
    This.

    See attachment for an example of how it can work for you.
    Attached Files Attached Files
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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: 3
    Last Post: 12-31-2012, 12:03 PM
  2. Help with an error 91 issue - assistance greatly appreciated.
    By Bighitch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2012, 02:08 PM
  3. Help would be greatly appreciated
    By lostonexcel in forum Excel General
    Replies: 7
    Last Post: 08-30-2011, 03:01 AM
  4. Replies: 2
    Last Post: 10-15-2010, 09:20 AM
  5. If then Help is greatly appreciated!
    By hansjhamm@yahoo.com in forum Excel General
    Replies: 11
    Last Post: 02-28-2006, 08:00 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