Help needed to add commets, arrows, etc to existing graph...

  • Thread starter Thread starter nick kno
  • Start date Start date
N

nick kno

I am wanting to add comments and arrows (that look proper) and fill i
the area between two lines on a line graph i have created in excel. Ca
someone please guide me on how this may be done...

I was thinking:
i. there may be a way to do it in excel that i am not aware of,
ii. there may be another charting program which will draw the chart
with all the frills from data exported from excel,
iii. there may be another program that allows me to add stuff t
already created excel charts,
iv. something else.

My aim is to export these graphs to word - they will form part of
report i am writting.

Any assistance would be much appreciated
 
Hi,

These things can be done using extra data series.

Arrows can be down using a custom marker, see this example.
http://peltiertech.com/Excel/ChartsHowTo/CustomSeriesFormatting.html

Comments, depending on the amount of text, can be down using data labels
linked to cells. Otherwise use textboxes although they will not move
with your data. See example of linking chart text holder to cell.
http://www.andypope.info/tips/tip001.htm

Shade between lines can be done by using an area chart and some formula
to calculate the values, see this example.
http://www.andypope.info/ngs/ng21.htm

When it comes to exporting to Word you can copy them as pictures. See
the paste picture example.
http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

Cheers
Andy
 
Back
Top