On 1/17/2012 6:15 PM, GS wrote:
> James Silverton brought next idea :
>> On 1/16/2012 5:33 PM, GS wrote:
>>> 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?
>>>
>>
>> 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
>
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!
--
Jim Silverton
Extraneous "not" in Reply To.
