Charting question: Line or Scatter or ... ?
David Thompson
dthmpsn1 at uiuc.edu
Fri Feb 15 07:16:40 PST 2008
Use a line chart with a second line to plot the scores of an
invisible student. Use a fill pattern of "none" for the invisible
student's line, and give the invisible student a score of 100 for the
first month. Don't have any records for months where testing has not
yet occurred, and have a procedure use ChangeObjects to adjust the
width of the chart based on the number of records, or alternatively,
place a white rectangle to the right of the chart and bring to front.
Change its dimensions with ChangeObjects to cover the untested
months. Use more white rectangles to hide the legends.
The only part of this I have ever actually tried was the invisible
line to establish the vertical scale, but I think it would work.
Dave
>Onward to my question...
>
>I have a preprinted grid sheet with a preprinted 'normal' curve on it
>that I am needing to plot measured values onto. The values are scores
>over set amount of time and can be accomplished either with a Line
>Chart or a Scatter Diagram chart (and connecting the dots) to show
>the trend over time. The problem is that I need for the chart to be
>at a predetermined scale regardless of the values plotted due to the
>preprinted underlying grid and 'normal' curves.
>
>ie. If a student's test scores were 50, 60, 65, & 70, these would
>typically plot either with an axis of 0 - 70 or perhaps a scale of 50
>- 70 (if I were to use a Non-Zero Axis) but what I am wanting is a
>scale from 0 - 100 as well as a preset typically longer axis for the
>time axis. I thought of having records for a second student as that
>would allow me to have the 2nd student with a 100 score so that I
>could force the size of the chart but that then caused a drop to zero
>for the 1st student for months that they have not yet tested.
>
>Month Score Invisible Student
>1 50 0
>2 60
>3 65
>5 65
>6 70
>7
>8
>9
>10 100
>
>I also need for the axis legends to NOT appear since the preprinted
>chart appears beneath. I thought of choosing a white text attribute
>but the color applies to the line color and not the text color.
>
>Any ideas?
More information about the Qna
mailing list