LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 113
Default line chart with separated X data

I need to create a main effects chart which plots three factors (x
data) against two levels (y data).
example http://www.itl.nist.gov/div898/handb...fs/dexmean.gif
This is simple enough using a line chart however I need to separate
the factors from each other, have them sit side by side rather than on
top of each other. So far the only way I have found to do this is to
make three charts, one effect each. One chart with a large chart area
and a reduced plot area. The other two charts have the chat area
hidden (border and fill off) and lay over the first chart so that the
plot areas are aligned side by side. This prototype is way too
cumbersome but I'm having a hard time figuring out how to do this in a
single chart.
Any help will be appreciated.
Thank
Robert
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving a line chart data point revises data table value in Excel ' Ed Smith Charts and Charting in Excel 2 November 16th 12 01:03 PM
External Data needs to be separated Mandy J.S. Excel Worksheet Functions 3 November 28th 07 11:29 PM
Cutting a line in a line chart when data series stops DannyS Charts and Charting in Excel 2 August 28th 07 10:38 AM
Line Drawing Between Separated Data Points ? Robert11 Charts and Charting in Excel 2 April 28th 05 11:11 AM
chart data line in two colors ReadyToLearn Excel Discussion (Misc queries) 3 April 8th 05 09:45 PM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"