Charting in EXCEL

[Grace]

I want to create a chart in EXCEL that, year by year, shows the range of a
certain variable with four stacked bars for quartiles of a universe. I
think I can figure out how to do this.

On each of those annual bars, I would also like to show the relative
position of two special extra data points. Probably they would be indicated
by a diamond and a circle, or something like that.

Though I know I could manually paste a diamond or circle onto each of these
yearly automated stacked bars in nearly the correct position, that would be
messy and a bit of work. And so I ask: Will EXCEL allow me to have those
two data points superimposed automatically, i.e., so if the data changes in
the spreadsheet, the position of the diamond will automatically adjust? I
don't know if this question falls under what EXCEL calls custom charting, or
it custom charting more refers to using their canned charts, saving your
particular headings and labels, etc, and that's it.

Kindly help me, you EXCEL charting aficionados!

Thanks,
Grace

 

[Anders S]

Hi Grace,

You can overlay one or more series to the chart and choose a different chart
type, for example a Line chart.
I don't know the exact commands in English but it goes something like

- right-click the chart area and choose Source data
- under the Series tab, click Add (Series) and select the source table. Click
OK.
- right-click a data point in the newly added series, choose Chart type and
choose Line Chart.
- play around with the Chart/Series, there is a myriad of options

I did this in Excel 2002, but the procedure is more or less the same in earlier
versions.

HTH
Anders Silven