Charts for Social Work

[scantor145]

Need help in creating 2 charts. Not sure if it’s possible in Excel.
Hopefully I’ll give enough details.

Chart #1

Y-axis: Range is 35 to 5, where the 35 is a minimum value at the botto
of the chart.
X-axis: There are actually three categories, but it is not a Bar Chart
per se.
Category Names(should appear at the top of the chart, not as an axi
label): Baseline, Intervention, and Follow-up (The X-axis should hav
gaps, so each category is separated; there actually should be no axi
label)

The Y-axis represents a score between 5 and 35. The score for th
Baseline is 22 and is supposed to be represented by a “dot”. Score
for Intervention and Follow-up have yet to be determined, but will als
be represented by a “dot”. After all three scores are plotted, the
should be connected with straight lines.

Chart #2

Y-axis: Number of sit-ups per day, where scale is 0 to whatever, sa
50
X-axis: Similar to the axis above, however, the axis for each categor
should be labeled M, T, W, T, F, S, S, and should have gaps as abov

 

[Jon Peltier]

Don't know what you mean by "gaps" in the axis. They'll be spaced accordingly.

1. It's a line chart. Data:

Baseline Y1
Intervention Y2
Follow-Up Y3

Select the data, run the chart wizard, and make the line chart. It will work even if
only one of the Y values is present, and when you add the others they will join the
first. Double click the Y axis, click on Scale tab, Min=5, Max=15, check Values in
Reverse Order. Double click the top axis (now along the top), click on Patterns tab,
check None for Major and Minor Tick Marks. Double click the series (one or more
points, depending how many Y's are filled in), Patterns tab, pick your marker and
make sure a line is specified.

2. Data:

M Y1
T Y2
W Y3
T Y4
F Y5
S Y6
S Y7

Select the data and run the chart wizard.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______