Forum Discussion
Excel Graph Formatting
How about the attached?
I think that does everything you asked for..
This was mostly just adding a 'dummy' series on a secondary axis to trick excel into adding the mirror numbers/check marks. For some reason, and i think its to do with the fact that we are dealing with negative numbers, although i could get the axis labels to appear top and bottom the check marks would only show at the top..
So I put my dummy series to use, made the value 1e-12 across the board, which gives you a series that just runs along the 'bottom' of the graph. I then drew a little vertical line (insert ->shape->line) and replaced the dummy series marker with that little line, to give me a fake check mark.. but it seems to work ok.
Finally the same sized major check mark.. I really thought there was a way to set the size of the plot area but I cant see it so maybe not. I resorted to drawing a box which i put on top of the graph at 0 and just resized the plot area until the first major tick marks lined up.. it works I guess?
How about the attached?
I think that does everything you asked for..
This was mostly just adding a 'dummy' series on a secondary axis to trick excel into adding the mirror numbers/check marks. For some reason, and i think its to do with the fact that we are dealing with negative numbers, although i could get the axis labels to appear top and bottom the check marks would only show at the top..
So I put my dummy series to use, made the value 1e-12 across the board, which gives you a series that just runs along the 'bottom' of the graph. I then drew a little vertical line (insert ->shape->line) and replaced the dummy series marker with that little line, to give me a fake check mark.. but it seems to work ok.
Finally the same sized major check mark.. I really thought there was a way to set the size of the plot area but I cant see it so maybe not. I resorted to drawing a box which i put on top of the graph at 0 and just resized the plot area until the first major tick marks lined up.. it works I guess?