+ Reply to Thread
Results 1 to 7 of 7

Formatting the x axis in a graph to shrink to fit only visible data

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Question Formatting the x axis in a graph to shrink to fit only visible data

    Hi everyone,

    I've had a look for an answer to this question but couldn't see anything, so hopefully you people can help as it's something I really need to try and resolve.

    I've uploaded a spreadsheet to filedrop link in the bottom of my postr. If you look at the second tab (graphs), you'll see there's a really big one to the right. Though there's hardly any data, it is tracking so many variables (it links to the table above it - 27 radio stations and 8 different regions), I'm having difficulty converting it into a graph that is manageable! I really need it in the one graph though.

    If you look at the x axis, that is where the regions are. The problem is, for each region the graph is leaving space for 27 radio stations to be tracked (making the graph HUGE and the data tiny and hard to read). In actual fact, there will be no additional data added to that graph, the only thing that will change is the values as they are, or will become, averages. So for example, the Brisbane region in the x axis will only ever track data from the data that is there already (ATN, 97.3, 104.5 Triple M, Beat 105 and Nova 106.9), nothing else.

    Is there a way then to make the graph realise that I only want to track certain radio stations for each region (which will mean all that additional space will be removed), or at least format the x axis so that it shrinks to fit only the data that is there?

    Your help would be greatly appreciated!

    Jamie.
    Attached Files Attached Files
    Last edited by jamietofs; 10-11-2012 at 07:40 AM.

  2. #2
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: Please help. Desperately need assistance in sorting this graph issue out.

    Hi,

    Your link is not opening. Therefore, it will be helpful if you attached the excel file in your post (Through advance option).
    However, to change your graph range (which will remove the unnecessary gaps) you can use dynamik range. Search google for dynamik range in excel. I hope you will get your answer.

    Best of Luck
    taps

  3. #3
    Registered User
    Join Date
    10-11-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Formatting the x axis in a graph to shrink to fit only visible data

    Thanks Arlu. I have done this now.

    Thanks for the response taps. I will go and check that option out. In the meantime, please see the document attached now! Any help would be greatly appreciated!

  4. #4
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: Formatting the x axis in a graph to shrink to fit only visible data

    Hi,

    Check below link:

    http://www.excelforum.com/excel-gene...en-as-0-a.html

    Regards
    taps

  5. #5
    Registered User
    Join Date
    10-11-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Formatting the x axis in a graph to shrink to fit only visible data

    Hi taps,

    Thank you so much for that. Unfortunately I don't have anywhere near the level of excel ability to be able to do that. Would you be able to help at all?

    Thanks again.

  6. #6
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: Formatting the x axis in a graph to shrink to fit only visible data

    Hi,

    I have tried myself and also show the same to my friend who is very expert in graph. However, we unbale to solve the problem. But if we get the answer then surely I will update this post.

    Please see the solution in below link.

    http://peltiertech.com/Excel/Charts/SqueezeColumns.html

    Regards
    taps
    Last edited by taps; 10-12-2012 at 06:39 AM. Reason: Got a real solution

  7. #7
    Registered User
    Join Date
    10-11-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Formatting the x axis in a graph to shrink to fit only visible data

    Hi Taps,

    Thanks for your help - I appreciate it!

    That link looks useful so I will give it a go.

    Cheers.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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