Segmenting "y" axis.

Question

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

Answer 1

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/

Answer 2

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

Answer 3

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

Answer 4

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

Older thread

Answer 5

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/