Need to create a line chart highlighting open, end, high, low values on the chart

**Solomon_raj** · 02-24-2013, 02:13 AM

Hi friends,

I have a three years historical NAV data of a fund, need to create a chart containing dates on X-axis and values on Y-axis.
The major unit on the X-axis should be Quarters and the values (open, close, low and high) should be highlighted.
I'd really appreciate if someone could help me plotting this data.
Also, please suggest me the formatting for the chart to make it look more appealing.

Please find the attachment.

Regards,
Solomon.

**dilipandey** · 02-24-2013, 07:00 AM

Hi Solomon,

See the attached file where I have used a pivot table :-
Historical NAV.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**Solomon_raj** · 04-07-2013, 07:26 AM

Thank you DiliPandey,

Is it possible to show only the high-low values on the chart with marker?

Regards,
Solomon

**dilipandey** · 04-07-2013, 07:40 AM

HI Solomon,

See the attached file where I obtained high and low values using formulas and plotted them in a chart. thanks.

Historical NAV.xlsx

Regards,
DILIPandey
<click on below * if this helps>

Need to create a line chart highlighting open, end, high, low values on the chart

LinkBack

Thread Tools

Rate This Thread

Display

Need to create a line chart highlighting open, end, high, low values on the chart

Re: Need to create a line chart highlighting open, end, high, low values on the chart

Re: Need to create a line chart highlighting open, end, high, low values on the chart

Re: Need to create a line chart highlighting open, end, high, low values on the chart

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions