View Single Post
  #8   Report Post  
Jon Peltier
 
Posts: n/a
Default

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/
_______