I would like to create a chart showing nutrient concentrations in
multiple lakes according to depth. I would like a single y-axis
showing depth, and multiple x-axis to show some data that's grouped
near 100 and other data that's grouped near 20 to appear close
together, rather than the annoying standard huge gap between 20 and
100. Also, I would like to have multiple horizontal sections on the
chart to graph the other lakes on the same chart.

On Tue, 26 Sep 2006, in microsoft.public.excel.charting,
filups said:

I would like to create a chart showing nutrient concentrations in
multiple lakes according to depth. I would like a single y-axis
showing depth, and multiple x-axis to show some data that's grouped
near 100 and other data that's grouped near 20 to appear close
together, rather than the annoying standard huge gap between 20 and
100. Also, I would like to have multiple horizontal sections on the
chart to graph the other lakes on the same chart.

Make multiple charts, one for each lake, and present them small and
close together on one page.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

You have at least three ways to do this.

1. Standard Line chart

2. Panel Charts are my name for Cleveland like trellis charts or Tufte like
small multiples charts. This page gives you example horizontal and vertical
panel charts.

http://processtrends.com/toc_panel_charts.htm

3. The third way is to use a dummy axis series for X axis. Assign 1 for your
20 values and 2 for your 100 values. Then use a dummy series to put the
desired X axis labels for your series.

http://processtrends.com/pg_charts_d...xis_series.htm

If either 2 or 3 looks useful, I'll be glad to walk you through the steps.

Correct my e-mail to contact me directly.

ve_me



"Del Cotter" wrote in message
...
On Tue, 26 Sep 2006, in microsoft.public.excel.charting,
filups said:

I would like to create a chart showing nutrient concentrations in
multiple lakes according to depth. I would like a single y-axis
showing depth, and multiple x-axis to show some data that's grouped
near 100 and other data that's grouped near 20 to appear close
together, rather than the annoying standard huge gap between 20 and
100. Also, I would like to have multiple horizontal sections on the
chart to graph the other lakes on the same chart.

Make multiple charts, one for each lake, and present them small and close
together on one page.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.