Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart with separated X data
Robert:
You want to make a horizontal panel chart. Here's a link to an Excel how-to. http://processtrends.com/pg_charts_p...l_XY_chart.htm If you run into trouble, send me the file and I'll try to make it for you. Kelly edit address and send to: koday*at*processtrends*dot*com "Robert H" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart with separated X data
Robert -
Rather than type out an all-text answer, I wrote an illustrated blog post to show just how easy this chart type is to create in Excel. It's a single simple line chart, and all the hard work is done through careful arrangement of the data. The blog post is located he http://peltiertech.com/WordPress/200...-effects-plot/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Robert H" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart with separated X data
Thanks Jon, This is an easy to understand method to work around the
limitations of Excel or should I say work within the framework of Excel. I dont like having to duplicate the data in a separate table but sometimes thats what you have to do... Thanks Again Robert On Mar 10, 8:45*pm, "Jon Peltier" wrote: Robert - Rather than type out an all-text answer, I wrote an illustrated blog post to show just how easy this chart type is to create in Excel. It's a single simple line chart, and all the hard work is done through careful arrangement of the data. The blog post is located he http://peltiertech.com/WordPress/200...main-effects-p... - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Robert H" wrote in message ... 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- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart with separated X data
That took me a little bit to figure out, your rework of my chart realy
helped. Labels are actually series data, and the separators are error bars. Clever! I'm adding a table for the Grand Mean that crosses the entire chart and naming the source data to feed the chart page data table. Later I might setup the tables to grow accordingy if I add factors but I may find that I dont change it that much... Thanks Robert On Mar 10, 8:04*pm, "Kelly O'Day" wrote: Robert: You want to make a horizontal panel chart. Here's a link to an Excel how-to. http://processtrends.com/pg_charts_p...l_XY_chart.htm If you run into trouble, send me the file and I'll try to make it for you. Kelly edit address and send to: koday*at*processtrends*dot*com "Robert H" wrote in message ... 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- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart with separated X data
Re duplication of data in a separate table...
Worksheet space is cheap. Formulas that retain linkage to the original data are easy. Formulas that set up the data range based on conditions[1] are easy. Time spent trying to do too many things with one set of data (monitor display, B&W printout display, chart source, calculation source, different reports for different audiences) is hard, the mental effort is tiring, the circles you run in get you nowhere. Bottom line: use the extra space for another data range. For every fine minutes you spend with your data, you save five hours of aggravation. (I'm thinking of trademarking that phrase.) [1] http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Robert H" wrote in message ... Thanks Jon, This is an easy to understand method to work around the limitations of Excel or should I say work within the framework of Excel. I dont like having to duplicate the data in a separate table but sometimes thats what you have to do... Thanks Again Robert On Mar 10, 8:45 pm, "Jon Peltier" wrote: Robert - Rather than type out an all-text answer, I wrote an illustrated blog post to show just how easy this chart type is to create in Excel. It's a single simple line chart, and all the hard work is done through careful arrangement of the data. The blog post is located he http://peltiertech.com/WordPress/200...main-effects-p... - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Robert H" wrote in message ... 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- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart with separated X data
Perfect delivery Jon. It sounds like you are speaking from
experience. Requardless, what you said is causing me to rethink how I do things. Your timing could not have been better. Robert On Mar 12, 8:42*am, "Jon Peltier" wrote: Re duplication of data in a separate table... Worksheet space is cheap. Formulas that retain linkage to the original data are easy. Formulas that set up the data range based on conditions[1] are easy. Time spent trying to do too many things with one set of data (monitor display, B&W printout display, chart source, calculation source, different reports for different audiences) is hard, the mental effort is tiring, the circles you run in get you nowhere. Bottom line: use the extra space for another data range. For every fine minutes you spend with your data, you save five hours of aggravation. (I'm thinking of trademarking that phrase.) [1]http://peltiertech.com/Excel/Charts/ConditionalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Robert H" wrote in message ... Thanks Jon, This is an easy to understand method to work around the limitations of Excel or should I say work within the framework of Excel. I dont like having to duplicate the data in a separate table but sometimes thats what you have to do... Thanks Again Robert On Mar 10, 8:45 pm, "Jon Peltier" wrote: Robert - Rather than type out an all-text answer, I wrote an illustrated blog post to show just how easy this chart type is to create in Excel. It's a single simple line chart, and all the hard work is done through careful arrangement of the data. The blog post is located he http://peltiertech.com/WordPress/200...main-effects-p... - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Robert H" wrote in message ... 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- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart with separated X data
Lots of experience. I follow the KISYM principle (Keep It Simple, You
Moron!), aka the KISS principle. Keeping it simple does not mean using fewer sheets or smaller ranges. KISS does not mean writing wildly complex formulas to spare the use of a helper column. KISS means use all the extra ranges and sheets I need, because in six months or six years when I return to that intricately nested formula, it would take me six hours to figure out, whereas the extra ranges is nearly self evident, especially if I throw around a few labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Robert H" wrote in message ... Perfect delivery Jon. It sounds like you are speaking from experience. Requardless, what you said is causing me to rethink how I do things. Your timing could not have been better. Robert On Mar 12, 8:42 am, "Jon Peltier" wrote: Re duplication of data in a separate table... Worksheet space is cheap. Formulas that retain linkage to the original data are easy. Formulas that set up the data range based on conditions[1] are easy. Time spent trying to do too many things with one set of data (monitor display, B&W printout display, chart source, calculation source, different reports for different audiences) is hard, the mental effort is tiring, the circles you run in get you nowhere. Bottom line: use the extra space for another data range. For every fine minutes you spend with your data, you save five hours of aggravation. (I'm thinking of trademarking that phrase.) [1]http://peltiertech.com/Excel/Charts/ConditionalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Robert H" wrote in message ... Thanks Jon, This is an easy to understand method to work around the limitations of Excel or should I say work within the framework of Excel. I dont like having to duplicate the data in a separate table but sometimes thats what you have to do... Thanks Again Robert On Mar 10, 8:45 pm, "Jon Peltier" wrote: Robert - Rather than type out an all-text answer, I wrote an illustrated blog post to show just how easy this chart type is to create in Excel. It's a single simple line chart, and all the hard work is done through careful arrangement of the data. The blog post is located he http://peltiertech.com/WordPress/200...main-effects-p... - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Robert H" wrote in message ... 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- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
External Data needs to be separated | Excel Worksheet Functions | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
Line Drawing Between Separated Data Points ? | Charts and Charting in Excel | |||
chart data line in two colors | Excel Discussion (Misc queries) |