Share via

Segmenting "y" axis.

Anonymous
2010-11-03T16:53:33+00:00

I am asking again because I already tried the John Peltier's version and it will not work because I need to put specific values in after 100.  Peltier, as far as I can get it, will only continue the values in the same succession.  I need to cout by 5's to 100 then by 100's.  I can do this using pivot tables and charts but, I'm not to sure how.

How so I segment the "y" axis. I need specific "how to".  I have to make my "y" axis look like this...

500
400
300
200
100
95
90
85
80
75
70
65
60
55
50
45
40
35
30
25
20
15
10
5
0

I am trying to chart individual production for oil wells (barrels per day). The values for my "y" axis need to reflect the production (like I have shown above) and the "x" axis reflects the months.  Not all of the wells will chart between the 0-500 some never fall below 100 and some never above but, they will be on individual charts and the "y" axis and the "x" axis must be identical for all the chart inorder for them to be compared. I need help or a place where I can watch a tutorial; meaning step by step.

Please Help,

Misty

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

5 answers

Sort by: Most helpful
  1. Anonymous
    2010-11-05T11:07:37+00:00

    Misty: Go to my website and get my email address, then send me a sample file. best wishes


    Bernard Liengme, Nova Scotia, Canada http://people.stfx.ca/bliengme/

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2010-11-04T20:56:15+00:00

    You don't explain why you have to have the broken y axis...

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2010-11-04T20:12:07+00:00

    Mr. Liengme,

    Is there anyway you can put a tutorial of how you did this on excel?  Maybe, I'm over thinking it, but I still am not getting the result I need.  I put the formula into the cells as you stated but, when I select the data I need to chart in a line graph I still get the same result.  The "y" axis in default depending on the data, not what I'm putting in as values.  I have no problem creating the values I want for the "x" axis but tremendous complications with the "y".  I guess what I'm asking is can you "dummy" it down alittle further?

    Pulling My Hair OUT,

    Misty

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2010-11-03T19:44:12+00:00

    Be sure to check out your other thread you started...

    Older thread

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2010-11-03T18:22:41+00:00

    Let's say you have data like this in A1:A100

    5

    10

    100

    120...

    Starting in C1 enter the numbers you want: 0, 5, 10, ... 100, 200,,,,

    In D1 enter =COUNTIFS($A$1:$A$100, ">="&C1,$A$1:$A$100,"<"&C2) ; copy down the column. For D26 (where C26 = 500) use =COUNTIF($A$1:$A$100, ">="&C25)

    Make a Bar chart


    Bernard Liengme, Nova Scotia, Canada http://people.stfx.ca/bliengme/

    Was this answer helpful?

    0 comments No comments