pl456
Registered User.
- Local time
- Today, 05:05
- Joined
- Jan 31, 2008
- Messages
- 150
I have a pie chart that picks up the legend from the underlying datasheet , however the number formats are incorrect.
I am getting numbers like 42398 of Nov-15 when I should be getting 11-15.
Any ideas how to resolve this, I have tried changing the format of the cell but I can't get it to realize that it is not dealing with dates but general numbers, not even selecting the general number format works which is also strange because the value above in the same sheet has general as its format and displays correctly.
I did try creating my own legend but the variable data means that the segment colours get reassigned and no longer match the legend.
I am getting numbers like 42398 of Nov-15 when I should be getting 11-15.
Any ideas how to resolve this, I have tried changing the format of the cell but I can't get it to realize that it is not dealing with dates but general numbers, not even selecting the general number format works which is also strange because the value above in the same sheet has general as its format and displays correctly.
I did try creating my own legend but the variable data means that the segment colours get reassigned and no longer match the legend.
