Hydrograph & Hyetograph in Excel
Hydrograph & Hyetograph in Excel
(OP)
Does anyone know how to place a hyetograph with a hydrograph in excel. I want to format it with the hyetograph as a secondary "Y" axis with the plot upside down above the hydrograph Any ideas – I have tried everything! – Thanks





RE: Hydrograph & Hyetograph in Excel
Perhaps you could share some of the "everything" that you've tried, and why you were unsatisfied with the results.
RE: Hydrograph & Hyetograph in Excel
Tricks you might consider to get the plot to appear the way you want it:
1. Over-write the default y-axis scales, so as to shift the minimum and maximum values for each axis, so that the graphs appear "stacked" on top of each other, instead of both plotting from the same base-line.
2. Plot "Values in reverse order" to plot one graph "upside down".
See attached sample - is this the sort of thing you want?
RE: Hydrograph & Hyetograph in Excel
RE: Hydrograph & Hyetograph in Excel
RE: Hydrograph & Hyetograph in Excel
RE: Hydrograph & Hyetograph in Excel
Julian's "values in reverse order" available by right-clicking on the axis, is the key.