Need a pivot chart without + or - simbol

[#1]

Hi,

I need to create a pivot chart where in we do not need to show the + and - symbols only hierarchy indentation should be maintained.

With no expand or collapse behavior as we just need a default view.

For example

World

     Asia

          India

                    North

                    South

                    East

                    West

          Pakistan

          Srilanka

          China

     Europe

          Germany

          UK

          France

          Rest of Europe

     America

          North America

          South America

For above pivot chart we dont want any further expansion or collapse.

I have attached one example of pivot chart.

Please advise

Thanks

Abdul

[sunny_talwar]

Looking to get this?

1) Check 'Indent Mode' on Style tab

2) Check 'Always Full Expanded' on the presentation tab

[#3]

Hi Sunny,

Thanks for your quick reply.

But Actually I don't want to expand all node. actually I want to expand only few nodes and rest of them non Expanded.

Rest of the view is fine as I dont get + and -.

Thanks in Advance

Amit

[sunny_talwar]

Unfortunately there is no way to selectively show + and - signs for each of the hierarchies. You either see them for all, or you don't see at all. I am not sure if there is a Macro or extension available which might address this concern, but personally, I have never seen anybody being able to resolve this issue

Best,

Sunny

[#5]

Thanks Sunny.

Can you please do me a small favour.

I need to export image of my chart with Header labels applied so do you have any macro code or something like this.

Thanks

Abdul