3D CHART ANNOYANCES
CANâT CHANGE 3D COLORS IN EXCEL 97
The Annoyance:
My company is near the end of its fiscal year, which means for the next few months Iâm stuck using Excel 97 to create 3D charts. Iâm trying my best, but the darn program keeps getting in the way. For example, thereâs a cool bit of clip art called AMVICTOR on the Office 97 CD. (Choose Insert â Picture â From File and navigate to the CLIPART\Popular folder on the CD to find it.) I added the image to the floor of my 3D chart, and then tried to change the floorâs fill color by clicking the floor, clicking the Fill Color button on the Formatting toolbar, and clicking a new color (actually a lighter shade of gray). Nothing happened. Why must Excel always make my life difficult?
The Fix:
Sometimes it does seem like Excel is doing its best to frustrate you, but take heart: it does this to everyone. If youâre using Excel 97 or 2000, adding a bit of clip art or pasting a drawing object into the floor or wall of a 3D chart prevents you from changing the color of the wall or floor using the Fill Color toolbar button. Go figure! But you can change the wall or floor fill colors by right-clicking the wall or floor, choosing Format Wall (or Floor), and clicking the square with the desired fill color. Bear in mind that changing the elementâs fill color removes the clip art or drawing object you pasted into the element, so youâll need to reinsert it into the floor or wall.
FLOOR TURNS BLACK IN 3D CHART
The Annoyance: ...
Get Excel Annoyances now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.