Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default I can't remove the Chart Area dotted lines around my charts.

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...
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default I can't remove the Chart Area dotted lines around my charts.

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JayDeVo" wrote in message
...
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...



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default I can't remove the Chart Area dotted lines around my charts.

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.

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JayDeVo" wrote in message
...
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...




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default I can't remove the Chart Area dotted lines around my charts.

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JayDeVo" wrote in message
...
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.

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JayDeVo" wrote in message
...
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...






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to remove dotted lines from entire excel page? gracie61103 Excel Discussion (Misc queries) 2 January 25th 08 12:07 PM
how do I remove dotted page break lines from my workbook pages? marcusaurelius Excel Discussion (Misc queries) 7 August 27th 07 11:44 AM
dotted lines around print area Gringo Excel Discussion (Misc queries) 2 August 7th 07 09:02 PM
To remove dotted lines in Microsoft Excel ? Mike Smithdorf Excel Discussion (Misc queries) 2 August 28th 06 08:54 PM
remove print area lines Mike Excel Discussion (Misc queries) 1 March 8th 06 09:01 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"