Your horizontal axis in the middle of the chart when you have negative values? You can place it at the bottom. Select your horizontal axis and CTRL+1 to format. Select Lables > Lable position > Select low.
In charts, long numbers tend to overlap and it's hard to read. To format a number to millions with 1 decimal place, select your range of numbers > CTRL+1 > Number tab > Custom > Type 0,,.0"M"
Using functions to create leading zeroes (totalling 6 characters). In cell B2 enter =TEXT(A2,"000000") but this doesnt work for text. In cell C2 enter =REPT("0",6-LEN(A2))&A2