Help Creating a n1.85 Hydraulic Graph in Excel

[2sBlind]

Hello all,

I am having trouble creating a hydraulic n1.85 graph in Excel and was hoping to get some steps for those who are less Excel inclind... ha! A little background, hydraulic n1.85 graphs are used in the fire protection industy to graph the flow and pressure of a water supply (city, storage tank, etc) and the flow and pressure required (demand) by a building's automatic sprinkler system in order to compare them and see if the supply meets the demand or if a fire pump needs to be installed.

The y-axis is used to plot pressures and is linear, but the x-axis is N^1.85 logarithmic scale, which is what I'm having trouble setting up in Excel. Any help (detailed steps would be much appreciated!) would be awesome.

Below are some examples of what the graph should look like.

\1
\1
http://www.pingfire.com/

Thanks!!!
2sBlind

[MrShorty]

Excel's built in log scales can only accept integer bases (at least in my version, and I doubt that has changed). I expect you will use a variation of Jon Peltier's arbitrary axis technique. http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Here is a tutorial for a reciprocal axis: http://peltiertech.com/Excel/Charts/RecipAxisChart.html
Creating your chart should be very similar.