none
Very weird chart behavior RRS feed

  • Question

  • For some reason, which makes no sense to me, when I graph some elements with aroun 11-12 records, I get graphs like this.

    This is correct; spreads on X-axis.  However, when I have to graph 12+ records, I get results like this.

    Now, the spreads are on the Y-axis.  Just because I have more than 12 or 13 records, or more.  If everything is essentially the same, I'd expect the graphs to be the same, but they are not.

    Can someone help me get this straightened out?  I want all graphs to appear like what I have in the 1st image.

    Thanks!!


    Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

    Thursday, September 17, 2015 3:44 PM

Answers

  • By default, Excel assigns the largest dimension (rows or columns) to the X-axis. Click in the chart and click the Switch Row/Column to 'correct' it.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by ryguy72 Thursday, September 17, 2015 5:01 PM
    Thursday, September 17, 2015 4:07 PM

All replies

  • By default, Excel assigns the largest dimension (rows or columns) to the X-axis. Click in the chart and click the Switch Row/Column to 'correct' it.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by ryguy72 Thursday, September 17, 2015 5:01 PM
    Thursday, September 17, 2015 4:07 PM
  • You are right!!  I never knew that!!

    I added a couple lines of code to test the dimensions of each axis and make the appropriate change, if needed.

    Thanks so much Hans!!


    Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

    Thursday, September 17, 2015 5:02 PM