Strange Chart Needed

  • Thread starter Thread starter carly
  • Start date Start date
C

carly

Is there anyway of producing a chart which contains 1 line of 0 - 100
where I can then plot 2 images (i.e. A Diamond & a Triangle) at
different points on the line?

For Example:

The Current Scoring for a Vendor is 80% but the standard scoring whic
is needed is 90%. I want to plot a Diamond at 80% and a Triangle at 90
to show that this vendor is currently under achieving.

Is this possible?

If so could someone point me in the right direction? Any help would b
greatly received.

Kind Regards

Carl
 
Hi Carly,

Here is one way of doing it using a xy scatter chart.
With the following data,

A1:= 0% B1:=50%
A2:= 100% B2:=50%
A4:= 80% B4:=50%
A6:= 90% B6:=50%

Select A1:B2 and with the chart wizard create a xy-scatter chart with
series in columns. This will be the 0 to 100% line. Select the data
series and format the border as required and the markers as none.

Right click the chart and display the Source data dialog.
Add new series, for the Xvalues reference A4, for the yvalues reference
B4. Format the series and change the marker to a diamond.

Again right click the chart and display the Source data dialog.
Add new series, for the Xvalues reference A6, for the yvalues reference
B6. Format the series and change the marker to a triangle.

To tidyup the graph you need to set the max of both scales to 1.

Cheers
Andy
 
Back
Top