Default Line Weight in Excel

G

Guest

How do I change the default setting for the "Line Weight" when creating
charts - at the moment all of my graphs are created with a very thin line
weight & I would like the standard to be thicker....
 
G

Guest

You can't change the default line weight. However, you can create a custom
chart with the heavier line weights and then use that custom chart instead of
Excel's defaults. To do so, click once on your finished chart with the
heavier line weights. Go to the standard toolbar and select Chart -> Chart
Type. In the Chart Type dialog box, select the Custom Types tab. Go to the
bottom of the dialog box and select User Defined. Add a name for your chart
and a description if needed. Hit the Add button and your custom chart will
be saved with all of Excel's given charts.
 
R

redbelly

John said:
... you can create a custom chart ...

You can also set your custom chart to be the default, as follows.

After you've added your chart type to Excel's list (as in John's
instructions):

Right-click on the chart
Click on Chart Type
Select the Custom Types tab
Click on the "User-defined" option
Select your custom chart type (so that it is highlighted)
Click the "Set as default chart" button

I wish more people would do this. Whenever I get a xeroxed copy of an
Excel chart with the default gray plot area, it is unreadable (gray
shades tend to become darker with xeroxing).

Mark

p.s. A question: occasionally, Excel "forgets" that I have set a custom
chart as the default, and reverts to the standard Excel default. I am
not sure what I have done, if anything, to cause this. Does anybody
else experience this, and/or know why it happens?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top