When I was moving my keyboard, I must have accidentally hit something that loaded a charting creation sheet over my datasheet. Now everytime I open my data sheet file the charting file is on top of my data sheet file and I cannot get rid of it. Any help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Charting Screen
- Thread starter retiring
- Start date
SkipVought
Programmer
Hi,
What have you tried to get rid of it?
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
When a wee mystic is on the loose..It's a Small Medium at Large!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Thread starter
- #3
Skip -- Yes I Have. The only close symbol closes the application and when I reopen the file the only thing visible is the chart template. The clear botton on the chart keyboard only eliminates elements on the template. I do not know where else to look. I tried Help and the MS knowlege base, but could not find anything that addreseed my problem. I should have said no when I initally saved it, but I was 80% done with my work and did not want have to redo it.
Thank you for responding to my post,
Thank you for responding to my post,
AnotherHiggins
Technical User
Right click on the chart - near the edge. Select Cut.
That's it.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
That's it.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
SkipVought
Programmer
There are various OBJECTS within the chart. As John has suggested, select near any outer edge to select the Chart Area object and then delete or cut.
Skip,
[sub]
When a wee mystic is on the loose..It's a Small Medium at Large!
[/sub]- Thread starter
- #6
AnotherHiggins
Technical User
Again - it has to be very near the edge. Even near the edge, if you click on one of the objects within the chart area (plot area, title, legend, etc.), the closest option you'll see is "clear". But if you click on an empty space near the edge, "Cut" will be an option.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
- Status