Page 1 of 1
Trendline on a histogram
Posted: Thu Aug 09, 2007 8:30 pm
by huisime
Hi,
I'm new to this program. Anyone know if it is possible to have a trendline (I'm using a moving average to be specific) appear as a line on a bar graph (histogram)? Right now the moving average appears as an ajoining bar. Thanks!
Cheers,
Sim
Posted: Thu Aug 09, 2007 9:33 pm
by jsc
David will probably say that this is on his todo list

, but right now the only thing I think you could do is just use a Options>Reference Lines and assign a y value. Part of the problem is that there is no way right now to combine a line graph and a bar chart - it's one or the other.
Or, you could create the histogram, change it from a bar chart to a linear x/linear y graph, add a symbol character for the node point, change the line style to "none" (so basically creating a scatter plot with the points representing the histogram count), and then add your smoothing line.
?
Jon
PS: You might also be able to fake a combo chart by starting with your histogram bar chart, turning into a scatter plot, then adding fat error bars to the curve. Use Vertical, Minus, 100%, 0" bar width, and .5" or more pen width. As long as you are happy with black as the color of the bar.
Posted: Thu Aug 09, 2007 10:39 pm
by huisime
Thanks Jon, I'll give the fat error bar scattergram a go.
Something else I noticed is the tick marks tend to be hidden behind the bars on a bar graph. I know you can set them to be outside but really there needs to be the option of keeping them on top. Might be something else to add to the to do list.
Cheers,
Sim
Posted: Fri Aug 10, 2007 3:11 pm
by DPlotAdmin
Sim,
It's there, just not obvious. Select Options>Symbol/Line Styles. In the lower right corner under "Grid line placement" (which should say "Grid line/tick mark placement", but that's a bit wordy) select either "and Curves" or "and Ref. lines".
Posted: Sat Aug 11, 2007 7:09 pm
by huisime
Thanks for the help David