Oh, that's not too bad.
Bubble chart with custom markers: make the bubble chart, draw the
desired shape in the worksheet, copy it, select the series, and paste.
Wow, square bubbles. The diamond is also a custom marker. See also
http://peltiertech.com/Excel/ChartsH...omMarkers.html
Custom error bars:
http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html
The dashed vertical line is an error bar on the diamond. the vertical
line at 1 can either be the category axis crossing at 1, or an error bar
on an invisible point. A bubble chart can't have an XY series as part
of a combination chart, as I like to do in my charts, but you can use a
bubble chart series for this with no border and no fill. Otherwise, any
of these error bar techniques for adding a line would work fine:
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Andy Pope wrote:
Here's an example cum description.
http://www.childrens-mercy.org/stats...orestPlots.asp
Looks like a bubble chart with custom markers(square and diamond) for
the weighting and custom x error bars for the confidence intervals.
Cheers
Andy
Jon Peltier wrote:
Any links to an example, so we can see one?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______