|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
05-05-2005, 03:06 PM
|
|||
|
|||
|
lines on bar charts
If I graph a simple straight trend line on a chart, how do I get it to run
behind the bars on my chart - rather than showing across the bars? 
|
|
#2
05-06-2005, 10:06 AM
|
|||
|
|||
|
RE: lines on bar charts
David,
To do so, you will need to create an overlay chart. An overlay chart is simply one chart laid over another. First create the Excel generated line and bar chart. The, make a copy of the chart. Delete or make tranparent everything in the second chart with the exception of the columns. Finally, overlay the second chart over the first. What I'm describing above sounds like a lot of work. However, Jon Peltier has an example with VBA code that automates much of the process. Jon Peltier describes this technique here. You can download the example with code from this link as well. http://peltiertech.com/Excel/Charts/AlignCharts.html ---------------------------- Regards, John Mansfield http://www.pdbook.com "DavidNHFCU" wrote: > If I graph a simple straight trend line on a chart, how do I get it to run > behind the bars on my chart - rather than showing across the bars?
|
|
#3
05-06-2005, 05:06 PM
|
|||
|
|||
|
RE: lines on bar charts
another way to do this is to use the data from the trend line and plot out a
curve representing the trendline. put it on a different axis so that it can plot behind th ecolumns. "DavidNHFCU" wrote: > If I graph a simple straight trend line on a chart, how do I get it to run > behind the bars on my chart - rather than showing across the bars?
|
|
#4
05-07-2005, 12:06 PM
|
|||
|
|||
|
Re: lines on bar charts
bj -
Did you try this? The trendline, for a series on any axis, is drawn in front of a bar or column series, on any axis. So are connecting lines for any marker-and-line style series (scatter and line charts), and error bars. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bj wrote: > another way to do this is to use the data from the trend line and plot out a > curve representing the trendline. put it on a different axis so that it can > plot behind th ecolumns. > > "DavidNHFCU" wrote: > > >>If I graph a simple straight trend line on a chart, how do I get it to run >>behind the bars on my chart - rather than showing across the bars?
|
|
#5
05-09-2005, 11:06 AM
|
|||
|
|||
|
Re: lines on bar charts
You are right, My suggestion does not work with Excel.. I remember doing it
so now I wonder what program I was using at the time. "Jon Peltier" wrote: > bj - > > Did you try this? The trendline, for a series on any axis, is drawn in front of a > bar or column series, on any axis. So are connecting lines for any marker-and-line > style series (scatter and line charts), and error bars. > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Peltier Technical Services > Tutorials and Custom Solutions > http://PeltierTech.com/ > _______ > > bj wrote: > > > another way to do this is to use the data from the trend line and plot out a > > curve representing the trendline. put it on a different axis so that it can > > plot behind th ecolumns. > > > > "DavidNHFCU" wrote: > > > > > >>If I graph a simple straight trend line on a chart, how do I get it to run > >>behind the bars on my chart - rather than showing across the bars? > >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
