broken scales for X axis

[Shoque]

Hi, i have two questions:
1) does anyone know how to create a broken scale for the X axis
(without drawing them in using the line function)?

2) I have on my X axis "Weeks" and on the Y axis "Viral concentration".
Using Tushar-mehta's flexible log scale produced a great Y axis, but
when I changed the X axis scales so that it doesn't start from "week
0", the Y axis values shift so that they're not aligned next to the
major tick marks anymore. How do i stop that from happening, without
physically moving the entire graph and/or the Yaxis values?

Thanks

 

[Jon Peltier]

#1: http://peltiertech.com/Excel/Charts/BrokenYAxis.html
Written for the Y axis, but the technique works for either. The URL above
has a step by step example and links to a couple other examples, including
Tushar's.

#2: I don't exactly understand your description.

- Jon

 

[Shoque]

Sorry about the incomplete description for #2

I used Tushar-mehta's flexible log scale to produce a Y axis, and
labelled the Y axis with the manual XY chart labeller (100, 1000, 10000
and so on). The data labels are aligned left of the tick marks nicely
when the X axis scales begin at "Week 0". However, I need the X axis to
start from "week 100" and when i change the X axis scales in excel, the
data labels for my Y axis will shift to the very left (thus
superimposing over my Y axis title - "Viral concentration") I've been
manually draggin each data label back to their original place but it
doesn't beat the precise alignment if the computer does it.

 

[Jon Peltier]

Don't you need to adjust the X values of the data points that comprise the
pseudo-axis?

- Jon

 

[Shoque]

Oh my goodness you're right! I didn't think of that. I changed the X
values for the pseudo axis to 100 and it worked perfectly. Thank you
very much!!

 

[Jon Peltier]

I was hoping it was something simple like this, because otherwise I had no
idea.

- Jon