X axis titles on logarithmic scatter chart.
NOTTNICK
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
Mike Middleton
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
"NOTTNICK" <nott...@googlemail.com> wrote in message
news:b8f0d237-9bd7-4cb4...@j24g2000yqa.googlegroups.com...
NOTTNICK
> 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
>
>
> news:b8f0d237-9bd7-4cb4...@j24g2000yqa.googlegroups.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
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
Mike Middleton
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
"NOTTNICK" <nott...@googlemail.com> wrote in message
news:f0880167-520d-48a5...@p8g2000yqb.googlegroups.com...
NOTTNICK
> Nick -
>
> 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.
>
>
> - Show quoted text -
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
Bernard Liengme
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
"NOTTNICK" <nott...@googlemail.com> wrote in message
news:9b2a7b29-2b8e-474a...@j19g2000yqk.googlegroups.com...