Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to remove dotted lines from entire excel page? | Excel Discussion (Misc queries) | |||
how do I remove dotted page break lines from my workbook pages? | Excel Discussion (Misc queries) | |||
dotted lines around print area | Excel Discussion (Misc queries) | |||
To remove dotted lines in Microsoft Excel ? | Excel Discussion (Misc queries) | |||
remove print area lines | Excel Discussion (Misc queries) |