Reduce the number of Series lables on line chart
Posted: Tue Dec 18, 2007 9:48 am
Hi,
I need to present a multi lines chart, my data source is as follows
In the real data each company can have the whole year (365 days) of values. When I show about 5 or more companies on the same chart using the default chart style it becomes difficult to distingish different companies by line color.
I turn on the Chart/Series Lables and set Value Type to Series Title, it sorts of work. Each line is labled by a company name on each data point, I need to only show the lables for say the first, last and middle point only. Is this possible?
Thanks
I need to present a multi lines chart, my data source is as follows
Code: Select all
Stock Value Date
Company1 20 1-jan-2007
Company1 21 2-jan-2007
Company1 20 3-jan-2007
Company2 32 1-jan-2007
Company2 31 2-jan-2007
Company2 30 3-jan-2007
I turn on the Chart/Series Lables and set Value Type to Series Title, it sorts of work. Each line is labled by a company name on each data point, I need to only show the lables for say the first, last and middle point only. Is this possible?
Thanks