Office

  • Office 2007
  • Office
  • All forums
Question

Remove shading from a surface chart in Excel 2007

Applies To:

I have a data set that is fairly noisy and I find that the lighting and shading that is applied to the chart is distracting me from seeing the general contours of the data. Is there a way to turn off the lighting/shading so that there is a solid color for data within a band?

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation
4 People had
this question

David Aastuen

David Aastuen

Was this helpful?

1

Vote

Answer

To remove the shading on surface charts requires a bit of code as there is no UI.

Select the chart. ALT+F11 to open VBE. CTRL+G to open immediate window. Enter following command and press Enter.

 

activechart.ChartGroups(1).has3dshading=false

 

Cheers,

Andy
www.andypope.info

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Andy Pope

Andy Pope MVP
Community Star
Cheers

Was this helpful?

 

Try this:-

 

Click in the Chart.

 

Chart Tools.

 

Design contextual tab.

 

Chart Styles group.

 

Click on Style 2 (because this is pretty, “solid”).

 

If my comments have helped please Vote As Helpful.

 

Thanks.

 

 

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

trip_to_tokyo

trip_to_tokyo MCC
Community Star

Was this helpful?

I actually have already chosen Style 19 as the best of the possible styles but I still have a problem with chart appearance. It is plotted as if there is a light in the upper right and the lower left side of every feature is lost in shadow.

 

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

David Aastuen

David Aastuen

Was this helpful?

Sorry 2 not 19; my mistake. " 2 is much clearer and more, "solid".
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

trip_to_tokyo

trip_to_tokyo MCC
Community Star

Was this helpful?

1

Vote

Answer

To remove the shading on surface charts requires a bit of code as there is no UI.

Select the chart. ALT+F11 to open VBE. CTRL+G to open immediate window. Enter following command and press Enter.

 

activechart.ChartGroups(1).has3dshading=false

 

Cheers,

Andy
www.andypope.info

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Andy Pope

Andy Pope MVP
Community Star
Cheers

Was this helpful?

Thanks Andy,

 

That did the trick but I am surprised that it isn't part of the user interface.

I will have to save the command someplace for later use.

-David

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

David Aastuen

David Aastuen

Message marked as answers cannot be deleted

To delete this message, first unmark this message as an answer, then delete it.

Reason to remove escalation


Merge

Enter the thread ID of the thread you are merging into


Reply will be posted to a public thread

You are replying to a public portion of this thread. To reply privately, click Cancel, click the Private Messages tab, and Reply on that private message.

Don't show this message again

To report abuse, sign in or continue without signing in

Thank you.

Report abuse

Abuse type:

Details (optional):

Report abuse

Abuse type:

Details (required):
Enter the characters you see (required):
Type the numbers that you see in the picture.
Play audio and type the numbers that you hear.
Show a different picture.

Sign in

Hotmail, Xbox Live, Messenger, or msn accounts will also work.

Don't have one of the above accounts?

Signing in...
This page will automatically update after you are signed in.
If you are having problems, you can close this message and try to connect again.