Prev: month count
Next: Multiple Bar Graphs on one chart
From: Bob on 19 Dec 2009 10:29
Hello,

Using Excel 2007

I'm embarrassed to ask this, as it's undoubtedly so simple, but just
can't find out how to do it.

Everything sure was simple in earlier versions !

Anyway, I have a simple chart that I created, linear, with the data
points being shown as squares. Guess it picked the squares on its own,
automatically.

I would like to change them to circles, and also their size.

How do do this, please ?

Thanks,
Bob
From: Bernard Liengme on 19 Dec 2009 12:56
Right click one of the squares in the chart
Select Format Data Series from popup menu
Right side of dialog: click Marker Options
Click Build-In and select your shape and size
To change colour: Marker Fill, then Solid Fill and select colour needed

best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Bob" <rgsros(a)notme.invalid> wrote in message
news:hgirg6$dm1$1(a)news.eternal-september.org...
> Hello,
>
> Using Excel 2007
>
> I'm embarrassed to ask this, as it's undoubtedly so simple, but just can't
> find out how to do it.
>
> Everything sure was simple in earlier versions !
>
> Anyway, I have a simple chart that I created, linear, with the data points
> being shown as squares. Guess it picked the squares on its own,
> automatically.
>
> I would like to change them to circles, and also their size.
>
> How do do this, please ?
>
> Thanks,
> Bob

From: Donnie on 8 Jan 2010 16:57
Is there some way to change the default size of the data points? They are
too large for most of the charts I create.
 | 
Pages: 1
Prev: month count
Next: Multiple Bar Graphs on one chart