ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Formatting Data point in Bar Chart (https://www.excelbanter.com/charts-charting-excel/218530-formatting-data-point-bar-chart.html)

Athena[_2_]

Formatting Data point in Bar Chart
 
Hi, I'm a research scientist and excel spreadsheets are part of our
livelihood. I could not find a way to change the format of a data point on
my bargraph with crosshatching, which patterns were available on the older
versions. There are a preset of texture options, but little fishies and
tweed are not a simple and professional way to respresent my data. Any
suggestions?

Jon Peltier

Formatting Data point in Bar Chart
 
The patterns are still part of Excel, but for whatever reason Microsoft
forgot to add the user interface controls to use them. However, Andy Pope
has written a nice little add-in that reinstates this capability:
http://www.andypope.info/charts/patternfills.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Athena" wrote in message
...
Hi, I'm a research scientist and excel spreadsheets are part of our
livelihood. I could not find a way to change the format of a data point
on
my bargraph with crosshatching, which patterns were available on the older
versions. There are a preset of texture options, but little fishies and
tweed are not a simple and professional way to respresent my data. Any
suggestions?





All times are GMT +1. The time now is 07:28 PM.

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