X axis titles on logarithmic scatter chart.

  • Thread starter Thread starter NOTTNICK
  • Start date Start date
N

NOTTNICK

OK, here's my problem.
I am wanting to make a scatter chart with a logarithmic x axis.
However, whatever I try I cannot get the x axis to show values, I just
get the initial value and nothing else.
Have tried all help files / google searches.
On the select data dialogue box, the edit feature for the x axis is
greyed out.
The values are listed clearly, but just won't display.
I have tried everything.
Tried both Excel 07 & XP.
Any ideas?
Thanks
Nick
 
Nick -

For your XY (Scatter) chart type, maybe you're not displaying a large enough
range of values on the horizontal axis. For the horizontal axis, choose
Format Axis | Axis Options, and select Auto for the Min and Max and Vertical
Axis Crosses. In the Select Data Source (Excel 2007) dialog box, the Edit
button for Horizontal (Category) Axis Labels should be disabled, as you have
observed. For an XY (Scatter) chart type, the horizontal axis labels are
determined by the Format Axis options. If all else fails, post a small
sample data set that illustrates your problem.

- Mike
http://www.MikeMiddleton.com



OK, here's my problem.
I am wanting to make a scatter chart with a logarithmic x axis.
However, whatever I try I cannot get the x axis to show values, I just
get the initial value and nothing else.
Have tried all help files / google searches.
On the select data dialogue box, the edit feature for the x axis is
greyed out.
The values are listed clearly, but just won't display.
I have tried everything.
Tried both Excel 07 & XP.
Any ideas?
Thanks
Nick
 
Nick  -

For your XY (Scatter) chart type, maybe you're not displaying a large enough
range of values on the horizontal axis. For the horizontal axis, choose
Format Axis | Axis Options, and select Auto for the Min and Max and Vertical
Axis Crosses. In the Select Data Source (Excel 2007) dialog box, the Edit
button for Horizontal (Category) Axis Labels should be disabled, as you have
observed. For an XY (Scatter) chart type, the horizontal axis labels are
determined by the Format Axis options. If all else fails, post a small
sample data set that illustrates your problem.

-  Mikehttp://www.MikeMiddleton.com


OK, here's my problem.
I am wanting to make a scatter chart with a logarithmic x axis.
However, whatever I try I cannot get the x axis to show values, I just
get the initial value and nothing else.
Have tried all help files / google searches.
On the select data dialogue box, the edit feature for the x axis is
greyed out.
The values are listed clearly, but just won't display.
I have tried everything.
Tried both Excel 07 & XP.
Any ideas?
Thanks
Nick
Click to expand...

Thanks Mike, tried that.
Here's the data
Note
x axis Frequency (Hz) 125 250 500 1000 2000 4000 This needs to be
logarithmic
y axis T60 (s) 1.47 1.40 0.99 0.68 0.56 0.56

(I notice that copy / paste has moved the Y axis data from the cells
selected)

Nick
 
Nick -

Here's what I tried in Excel 2007 SP2: I entered your X data (125 thru 4000)
in a column on the left and your Y data (1.47 thru 0.56) in an adjacent
column on the right. I selected the data, 2 columns by 6 rows, and chose
Insert | Scatter with Only Markers. Excel used 0 to 1.6 on the vertical axis
and 0 to 5000 on the horizontal axis. I selected the horizontal axis, right
clicked, and chose Format Axis from the shortcut menu. On the Axis Options
tab, I clicked Logarithmic scale Base 10, Close. Excel used 1, 10, 100,
1000, 10000 on the horizontal log axis. For an alternative scaling, I
right-clicked the horizontal axis, chose Format Axis | Axis Options, and
changed the Minimum to be Fixed 100 instead of Auto. Everything looks fine.

I don't understand "(I notice that copy / paste has moved the Y axis data
from the cells selected)."

If you need more assistance, please provide exactly which version of Excel
you are using and how your data are arranged, etc.

- Mike
http://www.MikeMiddleton.com



Nick -

For your XY (Scatter) chart type, maybe you're not displaying a large
enough
range of values on the horizontal axis. For the horizontal axis, choose
Format Axis | Axis Options, and select Auto for the Min and Max and
Vertical
Axis Crosses. In the Select Data Source (Excel 2007) dialog box, the Edit
button for Horizontal (Category) Axis Labels should be disabled, as you
have
observed. For an XY (Scatter) chart type, the horizontal axis labels are
determined by the Format Axis options. If all else fails, post a small
sample data set that illustrates your problem.

- Mikehttp://www.MikeMiddleton.com


OK, here's my problem.
I am wanting to make a scatter chart with a logarithmic x axis.
However, whatever I try I cannot get the x axis to show values, I just
get the initial value and nothing else.
Have tried all help files / google searches.
On the select data dialogue box, the edit feature for the x axis is
greyed out.
The values are listed clearly, but just won't display.
I have tried everything.
Tried both Excel 07 & XP.
Any ideas?
Thanks
Nick
Click to expand...

Thanks Mike, tried that.
Here's the data
Note
x axis Frequency (Hz) 125 250 500 1000 2000 4000 This needs to be
logarithmic
y axis T60 (s) 1.47 1.40 0.99 0.68 0.56 0.56

(I notice that copy / paste has moved the Y axis data from the cells
selected)

Nick
 
Nick  -

Here's what I tried in Excel 2007 SP2: I entered your X data (125 thru 4000)
in a column on the left and your Y data (1.47 thru 0.56) in an adjacent
column on the right. I selected the data, 2 columns by 6 rows, and chose
Insert | Scatter with Only Markers. Excel used 0 to 1.6 on the vertical axis
and 0 to 5000 on the horizontal axis. I selected the horizontal axis, right
clicked, and chose Format Axis from the shortcut menu. On the Axis Options
tab, I clicked Logarithmic scale Base 10, Close. Excel used 1, 10, 100,
1000, 10000 on the horizontal log axis. For an alternative scaling, I
right-clicked the horizontal axis, chose Format Axis | Axis Options, and
changed the Minimum to be Fixed 100 instead of Auto. Everything looks fine.

I don't understand "(I notice that copy / paste has moved the Y axis data
from the cells selected)."

If you need more assistance, please provide exactly which version of Excel
you are using and how your data are arranged, etc.

-  Mikehttp://www.MikeMiddleton.com








Thanks Mike, tried that.
Here's the data
Note
x axis Frequency (Hz) 125 250 500 1000 2000 4000 This needs to be
logarithmic
y axis T60 (s) 1.47 1.40 0.99 0.68 0.56 0.56

(I notice that copy / paste has moved the Y axis data from the cells
selected)

Nick- Hide quoted text -

- Show quoted text -
Click to expand...

Hi Mike,
Thanks for your help here.
It still doesn't do quite what I need.
Have a look here
http://www.bellows.org.uk/misc/data.htm
I've posted a chart I produced that has everything I need except
enough values on the x axis.
Also copied the x axis formatting.
Do you think it might be possible?

Cheers

Nick
 
But there are no integer log values between 100 and 1000.
100 =10^2 and 1000=10^3

Why not make a column of Log(x) values next to your y-values and make a
chart from that data
Then use a chart labeler to add values like 100, 500, 1000, 1500 to the
x-axis
Excel chart label

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com
Tushar's Hover Chart Label utility:
http://tushar-mehta.com/excel/software/chart_hover_label/index.html

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

Nick -

Here's what I tried in Excel 2007 SP2: I entered your X data (125 thru
4000)
in a column on the left and your Y data (1.47 thru 0.56) in an adjacent
column on the right. I selected the data, 2 columns by 6 rows, and chose
Insert | Scatter with Only Markers. Excel used 0 to 1.6 on the vertical
axis
and 0 to 5000 on the horizontal axis. I selected the horizontal axis,
right
clicked, and chose Format Axis from the shortcut menu. On the Axis Options
tab, I clicked Logarithmic scale Base 10, Close. Excel used 1, 10, 100,
1000, 10000 on the horizontal log axis. For an alternative scaling, I
right-clicked the horizontal axis, chose Format Axis | Axis Options, and
changed the Minimum to be Fixed 100 instead of Auto. Everything looks
fine.

I don't understand "(I notice that copy / paste has moved the Y axis data
from the cells selected)."

If you need more assistance, please provide exactly which version of Excel
you are using and how your data are arranged, etc.

- Mikehttp://www.MikeMiddleton.com








Thanks Mike, tried that.
Here's the data
Note
x axis Frequency (Hz) 125 250 500 1000 2000 4000 This needs to be
logarithmic
y axis T60 (s) 1.47 1.40 0.99 0.68 0.56 0.56

(I notice that copy / paste has moved the Y axis data from the cells
selected)

Nick- Hide quoted text -

- Show quoted text -
Click to expand...

Hi Mike,
Thanks for your help here.
It still doesn't do quite what I need.
Have a look here
http://www.bellows.org.uk/misc/data.htm
I've posted a chart I produced that has everything I need except
enough values on the x axis.
Also copied the x axis formatting.
Do you think it might be possible?

Cheers

Nick
 
Back
Top