Excel 2010 Chart with Log Scales 2

[MeGustaXL]

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!

 

[SkipVought]

Hi,

Some data might help.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

Here's an example. I used Solid Line rather than Automatic for the Minor Gridlines.

???

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[MeGustaXL]

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!

 

[SkipVought]

Log on Value axis: can't do

This is No Log, Minor Gridlines !000.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[MeGustaXL]

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!

 

[SkipVought]

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

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[MeGustaXL]

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!

 

[MeGustaXL]

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!

 

[combo]

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

combo

 

[MeGustaXL]

Thanks combo 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!

 

[SkipVought]

I’ll see your star and raise you one.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[combo]

Thanks!

combo