ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Bar Chart Format (https://www.excelbanter.com/excel-discussion-misc-queries/209301-bar-chart-format.html)

TLAngelo

Bar Chart Format
 
Is there a way to change the bar format so that not only is each bar a
different color, but each has a different pattern? We do not have color
printers so the pretty colors that I currently have in the chart will not
print. I need it to have a pattern as well. I see that you can put a
texture, but that's not exactly what I am looking for, I have a chart that
was created in PowerPoint that has polka dots with different spacing on each
bar.

Thanks,

Tania

Luke M

Bar Chart Format
 
Click on the column you want to change, and make sure you only have that
single column selected. (Not the entire series).

Then on the patterns tab, click on 'fill effects', and then go to pattern.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"TLAngelo" wrote:

Is there a way to change the bar format so that not only is each bar a
different color, but each has a different pattern? We do not have color
printers so the pretty colors that I currently have in the chart will not
print. I need it to have a pattern as well. I see that you can put a
texture, but that's not exactly what I am looking for, I have a chart that
was created in PowerPoint that has polka dots with different spacing on each
bar.

Thanks,

Tania


TLAngelo

Bar Chart Format
 
I don't see a "Patterns" tab. I am using 2007, when I click on the bar in
the chart that I want to change it says "series..." so I'm assuming that I
have selected the whole series. If I go to "Format" and then "Current
Selection", there isn't an option to select just one bar, only each series.

Tania

"Luke M" wrote:

Click on the column you want to change, and make sure you only have that
single column selected. (Not the entire series).

Then on the patterns tab, click on 'fill effects', and then go to pattern.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"TLAngelo" wrote:

Is there a way to change the bar format so that not only is each bar a
different color, but each has a different pattern? We do not have color
printers so the pretty colors that I currently have in the chart will not
print. I need it to have a pattern as well. I see that you can put a
texture, but that's not exactly what I am looking for, I have a chart that
was created in PowerPoint that has polka dots with different spacing on each
bar.

Thanks,

Tania



All times are GMT +1. The time now is 03:33 PM.

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