+ Reply to Thread
Results 1 to 3 of 3

How to keep scale of chart with secondary axis the same, after deleting the axis'

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    How to keep scale of chart with secondary axis the same, after deleting the axis'

    I have the following simple stock chart that charts volume, open, high, low, close, but if I want to eliminate both primary and secondary vertical axis, the scale jumps to that of volume chart. Is there a way to get rid of vertical axis' and still keep the chart at the same scale as I have now?

    Thanks
    Attached Files Attached Files
    You either quit or become really good at it. There are no other choices.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,811

    Re: How to keep scale of chart with secondary axis the same, after deleting the axis'

    What does it mean to you to "eliminate" or "get rid" of these axes? I find that I run into troubles if I clear/delete the axes, so I tend to "hide" them (format the axis with no line, no tick marks, no labels), but the axis is technically still present in the chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: How to keep scale of chart with secondary axis the same, after deleting the axis'

    Oh, ok, good trick. I'm used to just nuking them, but this seems to work well in this case. Thank you.

+ 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: 10-08-2014, 08:04 PM
  2. Replies: 1
    Last Post: 10-08-2014, 06:36 PM
  3. Secondary axis not picking up amended data for axis scale
    By AileenR in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 10-02-2013, 06:17 AM
  4. How to select Chart on sheet and set secondary axis scale
    By ExcelFed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2008, 12:26 PM
  5. [SOLVED] How to make Primary axis and Secondary X-axis have the same scale
    By AdamCPTD in forum Excel General
    Replies: 0
    Last Post: 07-14-2006, 09:15 AM
  6. Replies: 2
    Last Post: 08-12-2005, 08:05 AM
  7. Replies: 0
    Last Post: 07-13-2005, 05:05 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