ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   related to PIE charts N BAR charts (https://www.excelbanter.com/excel-discussion-misc-queries/147763-related-pie-charts-n-bar-charts.html)

manish

related to PIE charts N BAR charts
 
hello everyone,
i am using office 2007...
actually i have drawn some PIE charts and BAR charts with almost seven
variable each.. they are looking good in colors.. however i want the black n
white printout .. which is not giving the clear on the percentage in graphs..
is there any way to feed the PATTERNS in graphs for black n white picture..
like in books we have seen those things..

Earl Kiosterud

related to PIE charts N BAR charts
 
Manish,

Select the column or slice in which you want to use a pattern. Right-click - Format data
series (or data point, depending on your selection) - Patterns tab. In the Area section,
click "Fill effects," then the "Pattern" tab. Select a pattern -- there are many. You may
have to set the foreground to black and the background to white.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"manish" wrote in message
...
hello everyone,
i am using office 2007...
actually i have drawn some PIE charts and BAR charts with almost seven
variable each.. they are looking good in colors.. however i want the black n
white printout .. which is not giving the clear on the percentage in graphs..
is there any way to feed the PATTERNS in graphs for black n white picture..
like in books we have seen those things..




manish

related to PIE charts N BAR charts
 

i think you didnet get my question properly .. i need the pattern in the
graph not in the text.. to distinguish the seven colors in black n white
print.

"Earl Kiosterud" wrote:

Manish,

Select the column or slice in which you want to use a pattern. Right-click - Format data
series (or data point, depending on your selection) - Patterns tab. In the Area section,
click "Fill effects," then the "Pattern" tab. Select a pattern -- there are many. You may
have to set the foreground to black and the background to white.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"manish" wrote in message
...
hello everyone,
i am using office 2007...
actually i have drawn some PIE charts and BAR charts with almost seven
variable each.. they are looking good in colors.. however i want the black n
white printout .. which is not giving the clear on the percentage in graphs..
is there any way to feed the PATTERNS in graphs for black n white picture..
like in books we have seen those things..





Jon Peltier

related to PIE charts N BAR charts
 
Patterns such as Earl described are no longer available through the Excel
2007 user interface. You will have to rely on labels and shades of gray.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"manish" wrote in message
...

i think you didnet get my question properly .. i need the pattern in the
graph not in the text.. to distinguish the seven colors in black n white
print.

"Earl Kiosterud" wrote:

Manish,

Select the column or slice in which you want to use a pattern.
Right-click - Format data
series (or data point, depending on your selection) - Patterns tab. In
the Area section,
click "Fill effects," then the "Pattern" tab. Select a pattern -- there
are many. You may
have to set the foreground to black and the background to white.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"manish" wrote in message
...
hello everyone,
i am using office 2007...
actually i have drawn some PIE charts and BAR charts with almost seven
variable each.. they are looking good in colors.. however i want the
black n
white printout .. which is not giving the clear on the percentage in
graphs..
is there any way to feed the PATTERNS in graphs for black n white
picture..
like in books we have seen those things..








All times are GMT +1. The time now is 04:58 PM.

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