In message , Julie
writes
Im trying to do line chart with the excel 2007 and it seems almost
impossible. I've used excel 2003 and dont have a problem with making charts
of any kind but for some reason I'm trapped with 2007. For a paper in one of
my classes, i have to submit a graph to match the DAILY DATA from one of my
books i've made. In this graph i have to compare the following technology
companies.
CIEN
IDCC
CML
XATA
AAPL
KNM
and compare it all to
QQQQ (all in one graph)

Im trying to follow the steps from Excel help but its always leading me to
one stable line with one color. Please Help! If anyone knows a step by step
process to execute this graph correctly, it would be greatly appreciated.

It should be similar. Select the block of data you want to plot and then
fight with the dull^d^d^d^dwizard or pick an icon to get it to plot in
the style you want. If you can do it OK in XL2003 do it there then save
as an XLS file and load it into XL2007 (probably faster to get a half
decent result).

The default out of the box graph lines in XL2007 look like they were
drawn by a ham fisted 3 year old with a thick wax crayon and require a
lot of manual tweaking to be even vaguely presentable. Axis scaling is
now painful and tedious to use (and also doesn't work properly from
VBA).

There are zillions of other bugs in the pre SP1 version. My favourite is
the ticks on log scale graphs going past 10^8 (you get two ticks
labelled 10^7). Even with SP1 applied it is still horribly slow for
large amounts of data and fails to correctly display the legends if
there are more than about 20 series.

Regards,
--
Martin Brown

--
Posted via a free Usenet account from http://www.teranews.com