Negative Numbers in Table Show as Positive numbers in Graph

Question

Hi there, please help.

hansvogelaar · Answer

alvinfongg&nbsp;
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

alvinfongg · Answer

HansVogelaar&nbsp;Thanks for the help.&nbsp; Link:&nbsp;https://docs.google.com/spreadsheets/d/1wbTbm0rnL2Wrf_KFlasxcubz-umXTMx1/edit?usp=drive_link&amp;ouid=114840189741345856716&amp;rtpof=true&amp;sd=true&nbsp;The file provided has no corporate identifying information and in any event, data is provided to the extent necessary only.

hansvogelaar · Answer

alvinfongg&nbsp;
Thanks. Do you have a specific reason for plotting the last series (Economic Earnings) on the secondary axis? I think the chart looks better without it - see the attached version.

alvinfongg · Answer

HansVogelaar&nbsp;Thank you. &nbsp;&nbsp;1. Economic earning series appears to have run somehow. &nbsp;It should be on the primary yaxis.2. as it is almost 11pm out here, I will look at your suggested solutions (and assess the data) soonest possible.

Forum Discussion

Negative Numbers in Table Show as Positive numbers in Graph

4 Replies

Resources