Advice on simple graphs with Excel 2010

[James Silverton]

Can anyone point me to a good book on creating graphs with Excel?
Walkenbach's book that used be my bible is out of date. It was quite
easy with 2003; select the data and make a graph. The various choices
were obvious. Why did they have to change things with the damned ribbon?

I have several columns of data with labels and days as sequential
numbers going from 0 to current and I find difficulty in choosing axis
labels and markers. I want a conventional graph with its origin at lower
left and axes outside and a title for the chart. I have succeeded in
plotting the data and producing a legend for the graphs.

Thanks in advance.

 

[GS]

James Silverton wrote on 1/16/2012 :

Can anyone point me to a good book on creating graphs with Excel?
Walkenbach's book that used be my bible is out of date. It was quite easy
with 2003; select the data and make a graph. The various choices were
obvious. Why did they have to change things with the damned ribbon?

I have several columns of data with labels and days as sequential numbers
going from 0 to current and I find difficulty in choosing axis labels and
markers. I want a conventional graph with its origin at lower left and axes
outside and a title for the chart. I have succeeded in plotting the data and
producing a legend for the graphs.

Thanks in advance.

J-Walk has books for every version. Why not just upgrade your library?

 

[James Silverton]

James Silverton wrote on 1/16/2012 :

J-Walk has books for every version. Why not just upgrade your library?

I've had a look at several books including Walkenbach (in Barnes and
Noble's, I must admit) but I can't see any good way to produce a chart
with about 8 series and with the names of the series, which are the
column names, in the legend. I can get the series but not the legends. I
have to change the legends from Series1, Series2 etc. by hand. I don't
do this often enough to contemplate writing a macro but has anyone any
ideas? I won't argue with anyone who doesn't see why I should want to do
such a thing but I'll indicate that it involves stock prices in a portfolio.

 

[GS]

James Silverton brought next idea :

I've had a look at several books including Walkenbach (in Barnes and Noble's,
I must admit) but I can't see any good way to produce a chart with about 8
series and with the names of the series, which are the column names, in the
legend. I can get the series but not the legends. I have to change the
legends from Series1, Series2 etc. by hand. I don't do this often enough to
contemplate writing a macro but has anyone any ideas? I won't argue with
anyone who doesn't see why I should want to do such a thing but I'll indicate
that it involves stock prices in a portfolio.

Jim,
See if you can find anything here...

http://www.contextures.com/tiptech.html#C

 

[James Silverton]

James Silverton brought next idea :

Jim,
See if you can find anything here...

http://www.contextures.com/tiptech.html#C

Thanks very much but I did not find what I needed. What I finally did
was to enter this year's data at the end of last's, copy the sheet and
edit it to remove last year's stuff. Some care is needed but I've got my
legends!