I can't remove the Chart Area dotted lines around my charts.

J

JayDeVo

I have 2 computers and work on an excel file on each. However, one has excel
2003 and the other has excel 2007. When I work on the file in 2007 and then
try to view it in 2003, all the charts in the file get displayed with a
dotted line around the outside and on the bottom right it says "Chart Area".
I need to remove the dotted line and the Chart Area from being displayed...
 
J

Jon Peltier

I can't reproduce your problem. What kind of charts are these? Embedded or
standalone chart sheets? What type?

- Jon
 
J

JayDeVo

They're stand alone chart sheets. I move the file from one laptop to the
other. The file has about 50 standalone charts and a whole bunch of data.
Each chart had this show up. I just found to remove them - I click on the
dotted line and modify the chart area by changing the line color to white.
But this is just a short term fix since the line is still there, just white.
 
J

Jon Peltier

The line is probably the chart area border. You can format the chart area to
have no border at all. I don't know why you had the dotted line border in
the first place. When I tried it in 2007, I got a solid border.

- Jon
 

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