Best chart required for the data

Kushi Krishnappa

New member
Joined
Aug 7, 2017
Messages
19
Reaction score
0
Points
0
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
 

Attachments

  • Need best chart to show negative & Positive.xlsx
    312.5 KB · Views: 25
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.
 
Back
Top