chart deleting chart elements

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Chart, deleting chart elements

Chart, deleting chart elements

resolvedResolved · Medium Priority · Version 2010

Jagparvesh has attended:
No courses

Chart, deleting chart elements

A student wants to delete all the chart elements from the chart that he has created in an Excel worksheet. He has already selected the chart. Now, which of the following ways can he choose to accomplish the task? (Select all that apply.)
- By right-clicking each chart element, and then selecting Delete.
- By right-clicking each chart element, and then selecting Remove.
- By clicking the each element's button in the Labels group in the Charts Tools Layout contextual tab and then selecting None.
- By clicking the element's button in the Labels group in the Charts Tools Design contextual tab and then selecting None.

RE: Chart, deleting chart elements

I am unable to find element button in any Contextual tab of Chart.

RE: Chart, deleting chart elements

Hi Jagparvesh

With chart selected, on Design tab, within Data group, choose Select Data.

The "elements" are the items listed under Legend Entries (Series)for example, which can be selected and removed if necessary.

I hope this helps.

Kind regards

David

RE: Chart, deleting chart elements

So, only first option is correct in the question?

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 15 Aug 2014: Automatically marked as resolved.


 

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips


Server loaded in 0.07 secs.