1

I want to create a bar chart of the probabilities of two dice in Excel. This would appear to require the following data:

enter image description here

However, selecting that range and requesting a bar char results in both sets of data being plotted on the chart:

enter image description here

If I just select the result then I get the shape of graph I'm after:

enter image description here

But the axis is wrong - along the bottom, I need the numbers 2-12 rather than 1-11.

Controlling the axis of a graph in Excel seems unnecessarily complicated, and I presume there must be an easier way to do this - it's my ignorance that's stopping me. Is there a straightforward way to do this?

1

It's required to adjust the Axis Labels:

Axis Labels

Change your Axis Labels to match the Result column:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.