Charts - how can I get rid of shadows for good?

J

jpdphd

In Excel 11 (11.2.5), the points in xy(scatter) plots have "shadows" by
default. I am not Peter Pan! I do not care for shadows. They (like many
so-called 3D effects in Excel charts) may be artistic, but they distort
the data (and make me wonder if I should schedule an eye exam soon)!
Does anyone know of a way to customize the defaults of Charts beyond
specifying xy-scatter? I would also love to get rid of the default gray
plot area and the default y major grid lines, but the shadows are the
most annoying feature. I suppose I could write a macro..., but do you
have any other ideas?

Thanks in advance.
 
C

CyberTaz

You should be able to do so rather easily, although I can't remember if the
wording in MacXL is exactly the same.

Ctrl+Click any DataPoint & select Format Data Series - On the Patterns page
remove the check for Shadow & make any other changes you wish.

BTW - IF you click any DataPoint a 2nd time (*not* a dbl+click) you can
format the DataPoint independently of others in the same series. In fact,
you can access the Proerties for nay chart component & modify it as you
prefer based on its Format & other options.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Charts - how can I get rid of shadows for good? 3
setting defaults for data point size, color, shadow, etc. 3
How do I disable automatic chart creation in Excel? 1
How do I add a second y-axis in an xy(Scatter) chart? 2
Can I use xy scatter charts to plot absolute measurements? 0
How do I plot an XY (scatter) graph with two Y axes? 1
How do I get rid of this black box in my Excel charts? 2
How to get DATE-TIME column into chart as X-axis (domain) values 1

Top