Re: [Pen-l] excel question

[Doug Henwood <dhenwood@xxxxxxxxx>]

On Aug 28, 2008, at 1:54 PM, Jim Devine wrote:

> me:
> > > in MS Excel, when creating a data graph, is it possible to convert
> > > some series from lines into bars? how?
>
> Les Schaffer wrote:
> > click on the Chart Wizard and select Column for Chart type. that  
> > gives
> > vertical bars. or select Bar type for horizontal bar charts.
>
> thanks, but as far as I can tell, that changes all three of my series
> from lines into bars, whereas I'd like to change only one of them.

I'm using an old version of Excel for the Mac, but this works for me.  
Select the series you want to change by clicking on the line,  then  
choose "Chart type..." from the Chart menu, and then select column as  
type (making sure the box is checked saying for this series only).

Doug
_______________________________________________
pen-l mailing list
pen-l@xxxxxxxxxxxxxxxxxx
https://lists.csuchico.edu/mailman/listinfo/pen-l