X axis titles on logarithmic scatter chart.

On 3 Jan, 18:57, "Mike Middleton" wrote:
> 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[URL="http://www.MikeMiddleton.com"]http://www.MikeMiddleton.com[/URL]
>
> "NOTTNICK" wrote in message
>

> 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

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
 >> Stay informed about: X axis titles on logarithmic scatter chart. 

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
[URL="http://www.MikeMiddleton.com"]http://www.MikeMiddleton.com[/URL]



"NOTTNICK" wrote in message

On 3 Jan, 18:57, "Mike Middleton" wrote:
> 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[URL="http://www.MikeMiddleton.com"]http://www.MikeMiddleton.com[/URL]
>
> "NOTTNICK" wrote in message
>

> 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

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
 >> Stay informed about: X axis titles on logarithmic scatter chart. 

On 4 Jan, 00:13, "Mike Middleton" wrote:
> 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[URL="http://www.MikeMiddleton.com"]http://www.MikeMiddleton.com[/URL]
>
> "NOTTNICK" wrote in message
>

> On 3 Jan, 18:57, "Mike Middleton" wrote:
>
>
>
>
>
> > 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[URL="http://www.MikeMiddleton.com"]http://www.MikeMiddleton.com[/URL]
>
> > "NOTTNICK" wrote in message
>
>
> > 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
>
> 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 -

Hi Mike,
Thanks for your help here.
It still doesn't do quite what I need.
Have a look here
[URL="http://www.bellows.org.uk/misc/data.htm"]http://www.bellows.org.uk/misc/data.htm[/URL]
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
 >> Stay informed about: X axis titles on logarithmic scatter chart. 

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, [URL="http://appspro.com"]http://appspro.com[/URL]
John Walkenbach's Chart Tools, [URL="http://j-walk.com"]http://j-walk.com[/URL]
Tushar's Hover Chart Label utility:
[URL="http://tushar-mehta.com/excel/software/chart_hover_label/index.html"]http://tushar-mehta.com/excel/software/chart_hover_label/index.html[/URL]

best wishes
 >> Stay informed about: X axis titles on logarithmic scatter chart.