Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    OK here's another. We use a high/low graph to show intra-regional differences in data. However I format the feeder table, the graph always has the regions as the X and values as the Y. Is there an easy way to transpose the axes to show the regions on the Y axis?

    I've attached an example where I used a line graph with markers, removed the trend line and added high-low lines.

    You can see how we want it to look here:

    http://www.statistics.gov.uk/downloa..._Trends_38.pdf

    Click on the bookmark for 'Figure 4.6 Employment rates by region' in the Labour market chapter.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    In terms of easy, this is about as close as I can get. You may be able to do something neater using XY charts and dummy series, but it would take more work.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Rory, it's almost what I need but not quite. As it's going into a publication it needs to be in a specific style. I'll keep trying though, it's either get it perfect or drop the idea.

    Tony

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    What specifically needs altering?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •