Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Good afternoon. I've encountered an infuriating problem in Excel charts, and
I haven't found a solution in Excel or on Google. Has anyone else seen this? I'm using Excel 2K3, Windows XP, fully patched up. It's happend to other users on other computers, too. On some charts, the plot area for a chart can shrink, or occasionally grow, on it's own. I'll just click on the chart and the plot will shrink slightly, and possibly move slightly too. This happens each time I click on it, and sometimes when I open the workbook, or work on other charts. There's typically some visual corruption, too, the plot area box will remain visible, slightly. Once a chart gets "infected" it will not stop, and I have to either periodically stretch out the area again, or delete it and recreate it. This can happen on pie charts and line charts, that I've noticed. It seems to happen in larger Excel files, 5+ MB, and mostly only when charts' areas overlap, but that's not all there is to it: sometimes a lone chart will be affected, and sometimes overlapping charts are fine. I'm quite sure I'm not accidentally dragging the plot area, or a resize handle. It'll happen when I'm moving the chart, or clicking on the labels. It's not from deleting or resizing rows or columns, all of my charts are move-but-don't-resize and I'm not working with rows or cells at all on these worksheets. This is especially maddening when I'm linking Excel charts into PowerPoint. I may paste in four equal-sized pie charts, and after some twiddling I come back and one pie has shrunk to a pinpoint. On other slides I have line charts neatly lined up with a PPT rectangle object to highlight a section, and every time I open the file I need to adjust the chart's plot area again. I don't remember seeing this before I started working with PowerPoint, so I suppose there could be something about the OLE linking process that causes Excel to handle charts differently, but if so it only affects a few. This seems like a cumulative rounding error, maybe. Has anyone seen this? Any ideas how to stop it? I'll give you my first born son! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Plot area shrinks and shifts | Charts and Charting in Excel | |||
Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
is it possible two different colours in a chart plot area ? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |