am i an idiot ....

[Sonka]

On 2003-October-Thursday - 20:07:20 was 62.37-182-adsl-pool.axelero.h
( Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) ) with th
following IP 81.182.37.62 on your boar

Is there any way to sort the data in an Excel chart. I do not mean b
simply sorting the worksheet source data, but automatically withi
the chart. It seems quite a simple idea to me but I cannot find ho
to do it anywhere in Exce

HEEEEEEEEEEEELP

 

[Jon Peltier]

Sonka -

No, you're not an idiot. Some things seem like they'd be easy, but for
some reason Excel makes them hard.

Data points are plotted in the chart in the order they appear in the
worksheet. A line chart or other chart type with a category axis places
the points left to right according to worksheet position of the data.
Points in an XY Scatter chart are also plotted in order, which doesn't
affect their position along the X axis (since they're plotted by X
value), but the lines connecting points follow the order in the
worksheet. If the X axis is a time scale axis, the points are plotted
left to right in increasing order of time; this is the only case in
which Excel sorts the data between the worksheet and the chart.

The bottom line is that, if you want you points plotted in a certain
order, you need to sort the values in the worksheet.

- Jon

 

[Guest]

-----Original Message-----
On 2003-October-Thursday - 20:07:20 was 62.37-182-adsl- pool.axelero.hu
( Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) ) with the
following IP 81.182.37.62 on your board

Is there any way to sort the data in an Excel chart. I do not mean by
simply sorting the worksheet source data, but automatically within
the chart. It seems quite a simple idea to me but I cannot find how
to do it anywhere in Excel

HEEEEEEEEEEEELP.

.
leave some rows open at thetop row let say 8.then name

the title for your database.move one row down to enter a
field in each column.select both rows then click data on
your menu.Then click form... this should show your
database with all fields. enter data for each field click
next for a new record.When done click close. you can also
have quick access to your database by selecting your
range and clicking in the name box. Type a name for your
database .any name not valid will create a prompt from
the wizard. if no prompt go to name box whenever you need
that database Oh press enter after you type name