Chart, deleting chart elements

Resolved · Medium Priority · Version 2010

Fri 31 Jan 2014, 16:43 Delegate Jagparvesh said...

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.

Fri 31 Jan 2014, 16:45 Delegate Jagparvesh said...

RE: Chart, deleting chart elements

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

Mon 3 Feb 2014, 16:09 Trainer David said...

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

Mon 3 Feb 2014, 17:29 Delegate Jagparvesh said...

RE: Chart, deleting chart elements

So, only first option is correct in the question?

Fri 8 Aug 2014, 16:23 Trainer Cindy said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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