How to make a graph in excel with 2 side by side x axis and one y axis

My question is how to figure a graph with 2 x-axis side by side with one y-axis. For clarification, i mean 2 x axis with minimum value (zero) at the middle and for example maximum value 15 at right for the first x axis and 20 at the left for the second x axis. While for y-axis, it will be in the middle intersecting with zero value. Here is the link for the graph i need with the difference, i need both x values positive.

Thanks

4

1 Answer

Assuming you can generate the graph and the only problem is the numbers on the horizontal axis you can do the following:

1. generate your graph as shown in your screencap.

2. select, then right-click on the bottom axis labels and choose "Format Axis from the dropdown menu

3. Under "Number" choose "Custom" and add the following custom number format:

   0; 0; 0

You chart's horizontal axis should now look like this:

With the data from the screencap in your comment below:

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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