MS Excel / VBA help thread

You are reading a single comment by @lf and its replies. Click here to read the full conversation.

•

lf
If you were doing 2 charts you could do one of swaps and one of comparisons, with a line for IS and a line for BS on each chart. That would make it more comparable than the two charts you have currently.

I can't figure out how to make it so there isnt a big gap to the left and right

Right click on the axis labels at the bottom > Format Axis > Select 'On tick marks' in then Axis position section

What you can do to put it all on one chart is to have it formatted like below, if you merged the three cells with Comps together and did the same for Swaps, then you end up with like a little sub-label on the chart. explaining that badly.
```
                   IS    BS
Comps    9
Comps    18
Comps    27
Swaps    9
Swaps    18
Swaps    27
```

•

boredom in reply to @lf

Right click on the axis labels at the bottom > Format Axis > Select 'On tick marks' in then Axis position section

Perfect thanks. Yeah I wasnt sure how best to show it. I went with what I had above with the two different sorts on the 2 separate graphs. I'll find out what my lecturer says soon enough.

What you can do to put it all on one chart is to have it formatted like below, if you merged the three cells with Comps together and did the same for Swaps, then you end up with like a little sub-label on the chart. explaining that badly.

No you explained that well, I might have used that if I'd seen it in time. Sure I'll know for next time!

About

Avatar for lf @lf started