ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   using a picture as a stacked bar in chart (https://www.excelbanter.com/charts-charting-excel/237177-using-picture-stacked-bar-chart.html)

Jaimed1010

using a picture as a stacked bar in chart
 
I am wondering how to use a picture (a barrel or a glass) instead of the bar
in a stacked bar chart. So rather than have a stacked bar with 4 colors I
would have a picture of a glass with the 4 colors.

Is this possible? and if so how can I do this? I've seen it in other
presentations, but I don't know if it used other applications to create.

Thanks

Andy Pope

using a picture as a stacked bar in chart
 
Hi,

You can use a picture as the fill picture. You will need 4 images to get
different coloured glasses.
Double click a series. On the Pattern Tab click Fill Effects. On the
Picture tab use Select Picture.

For xl2007 the Picture option is on the Fill tab of the series format
dialog.

More information,
http://peltiertech.com/Excel/ChartsH...tomStacks.html

Cheers
Andy

Jaimed1010 wrote:
I am wondering how to use a picture (a barrel or a glass) instead of the bar
in a stacked bar chart. So rather than have a stacked bar with 4 colors I
would have a picture of a glass with the 4 colors.

Is this possible? and if so how can I do this? I've seen it in other
presentations, but I don't know if it used other applications to create.

Thanks


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com