Home |
Search |
Today's Posts |
#1
|
|||
|
|||
coloring the sides of 3d bars in a different color than the front?
Hi,
is it possible to give the sides of a 3d bar another color than the front? Greets Xaver |
#2
|
|||
|
|||
You can apply a picture to either the front or the side:
Create a picture in a graphics program (e.g. MS Paint) that is just a block of colour. In Excel, select the chart series that you want to colour Choose FormatSelected Data Series On the Patterns tab, click the Fill Effects button On the Picture tab, click the Select Picture button Find the colour block picture that you created, and select it, then click Insert For 'Apply To', check Sides or check Front Click OK, click OK Xaver Hinterhuber wrote: is it possible to give the sides of a 3d bar another color than the front? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hello Debra,
thank you for this great tip. My search time for this is summing up to several days. THANKS. Greets Xaver "Debra Dalgleish" schrieb im Newsbeitrag ... You can apply a picture to either the front or the side: Create a picture in a graphics program (e.g. MS Paint) that is just a block of colour. In Excel, select the chart series that you want to colour Choose FormatSelected Data Series On the Patterns tab, click the Fill Effects button On the Picture tab, click the Select Picture button Find the colour block picture that you created, and select it, then click Insert For 'Apply To', check Sides or check Front Click OK, click OK Xaver Hinterhuber wrote: is it possible to give the sides of a 3d bar another color than the front? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
You're welcome. Thanks for letting me know that the tip helped you.
Xaver Hinterhuber wrote: Hello Debra, thank you for this great tip. My search time for this is summing up to several days. THANKS. Greets Xaver "Debra Dalgleish" schrieb im Newsbeitrag ... You can apply a picture to either the front or the side: Create a picture in a graphics program (e.g. MS Paint) that is just a block of colour. In Excel, select the chart series that you want to colour Choose FormatSelected Data Series On the Patterns tab, click the Fill Effects button On the Picture tab, click the Select Picture button Find the colour block picture that you created, and select it, then click Insert For 'Apply To', check Sides or check Front Click OK, click OK Xaver Hinterhuber wrote: is it possible to give the sides of a 3d bar another color than the front? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color Palette Issue | Excel Discussion (Misc queries) | |||
How do I connect cell color to bar chart color? | Charts and Charting in Excel | |||
Changing color in color palette | Setting up and Configuration of Excel | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |