Help needed with Excel Chart

i can draw Excel Chart in Figure 1, but i want to add red circles to Excel Chart like shown in Fig 2 which i dont know how to do???????

makhan10 said:

i can draw Excel Chart in Figure 1, but i want to add red circles to Excel Chart like shown in Fig 2 which i dont know how to do???????

Hi there

I think if you follow this -- should at least help you get started.

Excel Worksheet Objects

Cheers
jimbo

Try3 said:

1 Click on your line to select it
2 Right-click and select Format data series
3 Select Marker options, Built-in, Type - circle

4 Still in Marker options, Built-in, select a Size to suit you. Size 10 is pretty big and is roughly what you have drawn.
5 Then Marker fill, No fill will match your illustration's circles but you can experiment to suit your needs.

Denis

thanks for your help, but i am sorry i could not explain my question properly, i want blue line to have red circles, lets say at 1.5 and 4.7 points of x-axis

Try3 said:

Excel does not provide for freehand drawing on charts.

You could take a screenshot of your chart then edit it in, for example, MSPaint to add your circles.

Denis

ok thnx