Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2006

Tip: Looking for answers? Try searching our database.

multiple x-axis with horizontal separation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
filups - 27 Sep 2006 01:27 GMT
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.
Del Cotter - 27 Sep 2006 07:02 GMT
>I would like to create a chart showing nutrient concentrations in
>multiple lakes according to depth.  I would like a single y-axis
[quoted text clipped - 3 lines]
>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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

Kelly O'Day - 27 Sep 2006 14:01 GMT
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_dummy_axis_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.

Koday@processtrends.com.remove_me

>>I would like to create a chart showing nutrient concentrations in
>>multiple lakes according to depth.  I would like a single y-axis
[quoted text clipped - 6 lines]
> Make multiple charts, one for each lake, and present them small and close
> together on one page.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.