ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to I make the Excel horizontal axis count up then down (https://www.excelbanter.com/charts-charting-excel/202811-how-i-make-excel-horizontal-axis-count-up-then-down.html)

Dave

How to I make the Excel horizontal axis count up then down
 
I am trying to fit two sets of data on the same chart to make an acid/base
titration curve.
I need the horizontal axis to could from 0 to 25 then back to 0.
That way if the increments where in units of 25 the axis would be numbered
like this:

0 --------- 25 ----------0

Jon Peltier

How to I make the Excel horizontal axis count up then down
 
You can use a line chart, with labels of 0 through 25 through 0. These
labels will not have any numerical significance. Or you can really plot X
values ranging from 0 to 50, but add fake axis labels that follow your
pattern.

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
http://peltiertech.com/Excel/Charts/...tml#AxisScales

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"dave" wrote in message
...
I am trying to fit two sets of data on the same chart to make an acid/base
titration curve.
I need the horizontal axis to could from 0 to 25 then back to 0.
That way if the increments where in units of 25 the axis would be numbered
like this:

0 --------- 25 ----------0




PBezucha

How to I make the Excel horizontal axis count up then down
 
Learn more about the topic on

http://people.stfx.ca/bliengme/ExcelTips/Titration.htm
--
Petr Bezucha


"dave" wrote:

I am trying to fit two sets of data on the same chart to make an acid/base
titration curve.
I need the horizontal axis to could from 0 to 25 then back to 0.
That way if the increments where in units of 25 the axis would be numbered
like this:

0 --------- 25 ----------0



All times are GMT +1. The time now is 12:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com