INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Excel 2010 Chart with Log Scales

Excel 2010 Chart with Log Scales

(OP)
Hi,

I'm charting my data, and in order to get a straight line regression on it, I'm using Logarithmic X and Y axes, then putting a Power trendline on it.

It all works just fine, but the data tends to be all bunched between one or two gridlines on the axis. For instance, X-values between 20,000 and 30,000 units. That gives me 2 'Minor' gridlines on the chart, one at each end, and no intermediate lines. Is there a way I can specify a finer gridline spacing, say at 100's?

I've fudged it before with a dummy 'axis'series and error bars with "X-Y Chart Labeller", but I'm too idle to set that up every time.

Chris

Someday I'll know what I'm donig...damn!

RE: Excel 2010 Chart with Log Scales

Hi,

Some data might help.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Excel 2010 Chart with Log Scales

(OP)
HI Skip, thanks for the example.

Try This with Hours on the X and Count on the Y. Making this a Log-scale chart gives a near-vertical line between the 20000 and 30000 gridlines. I'd like those to be the Min and Max of the X-Axis, with 1000-hour minor gridlines between them.


Hours Count
20241 64
20241 65
20666 66
20666 67
20666 68
20666 69
20666 70
20982 71
20982 72
20982 73
21499 74
21499 75
21499 76
21499 77
21499 78
21839 79
22071 80
22233 81
22612 82
23127 83
23127 84
23127 85
23127 86
23127 87
23345 88
24338 89
24338 90
24559 91
24559 92
24909 93
25131 94
25131 95

Chris

Someday I'll know what I'm donig...damn!

RE: Excel 2010 Chart with Log Scales

(OP)
The Chart I'm working with has Running hours on the X-Axis, and Count of Events on the Y-Axis. Both axes are set to Logarithmic, and the data Series has a Power Trendline applied. All works great, and the Trendline equation gives me the results I expect and require.

It's just that the data set is inconveniently place between widely-spaced logarithmic gridlines. If I define the Max/Mins of both axes to be 20000-30000 on the X, and 50-100 on the Y axis, ther are no Minor gridliines visible. This makes it difficult to extrapolate or interpolate the data visually, as with graph paper.

I can fake the gridlines with dummy series with their error bars named using X-Y Chart Labeller, but isn't there a more built-in way of doing this?

See the attached chart for an example.

Chris

Someday I'll know what I'm donig...damn!

RE: Excel 2010 Chart with Log Scales

I'm agreeing with you. Can't seem to find a way to show minor grid lines.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Excel 2010 Chart with Log Scales

(OP)
I know Skip, thanks. I don't think Excel provides that functionality. It's just a presentation thing, really. I can look at the chart as it is and understand it, but the people in floors above like to see grids so they can say "So what's with the gap between, ooh 23,300 and 24,300-ish?" Come to think of it, maybe leaving the grid off isn't such a bad idea after all!

Chris

Someday I'll know what I'm donig...damn!

RE: Excel 2010 Chart with Log Scales

(OP)
I guess the nub of it is that the limits of the axis as I've set them, are already Minor Grid points!

Chris

Someday I'll know what I'm donig...damn!

RE: Excel 2010 Chart with Log Scales

2
Not exactly minor axes, but this approach may help a little.

combo

RE: Excel 2010 Chart with Log Scales

(OP)
Thanks combo 2thumbsup That's the reminder I needed! No need for XY Chart Labeller (fantastic though it is)

Chris

Someday I'll know what I'm donig...damn!

RE: Excel 2010 Chart with Log Scales

I’ll see your star and raise you one.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Excel 2010 Chart with Log Scales

Thanks!

combo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close