When importing data from Excel to create a Sized Pie Chart, I select for example 6 Columns/Data Fields to map.
These columns contain monetary values, for example £25954.35
At the Format the Legend stage I select 5 (could be 4,6,3,8,) Discrete Equal Ranges. I accept the Pre-determined Range label and finish the mapping process.
My finished map contains the legend based on my choices of Data Fields etc. However it will not show the complete Range against each Sized Pie Chart, only the first part of the range for each size.
I can make it show the complete range by going back into the Legend and deleting the word "to" in the Range Label and replacing it with a "- "
Why does it not do it automatically?
The data in Excel has been correctly formatted.
What am I doing wrong? Please help if you can.