ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Piviot Charts (https://www.excelbanter.com/charts-charting-excel/340-piviot-charts.html)

Jesse

Piviot Charts
 
Hello,

I've created a piviot chart, but each chart is different. There are around
500 charts, how can I make all the charts the same.

Ken Wright

A tad more detail perhaps <g

Your text is somewhat confusing and doesn't detail the problem.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Jesse" wrote in message
...
Hello,

I've created a piviot chart, but each chart is different. There are around
500 charts, how can I make all the charts the same.




Del Cotter

On Sat, 8 Jan 2005, in microsoft.public.excel.charting,
Jesse said:

I've created a piviot chart, but each chart is different. There are around
500 charts, how can I make all the charts the same.


It's not easy; as usual MS decides it knows better than the user, and
doesn't give the user the opportunity to override the application's
choices of chart size, shape, format etc.

What particular problems are you having? Some of them, like the pivot
chart not showing categories in the chart for which there are zero
instances, can be worked around with a little effort.

--
Del Cotter
Thanks to the recent increase in UBE, I will soon be ignoring email
sent to . Please send your email to del2 instead.


All times are GMT +1. The time now is 06:59 AM.

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