PDA

View Full Version : Best chart required for the data



Kushi Krishnappa
2017-08-29, 06:52 AM
Hello good morning every one,

I have to present the chart to the management team, will be requiring the help in choosing the best chart for my data, which should highlight Loss (negative) & profit (positive) in one go

Please help me with plating the best chart type for my data.

I tried pie chart, but did not the option of scaling to reduce the figure values to the extent of "000.





regards,
Kushi

Bob Phillips
2017-08-29, 11:06 AM
I would use a bar chart, set the format of the numbers to #,##0,"K" so you get 500 not 500,000, or even #,##0,,"M". Set the label position to Next To Axis so that it doesn't overlay.