keep values but replace data point labels on line charts

[Jim]

I have a line chat with month year as x axis.  y acids is a percentage.in the data set I have date as month year, amount to show as percentage and an additional text field.  I want the chat to plot out the percentages with point labels that instead of using the amount as a PerCentage,  cognos show s the text, but aligned at the proper y axis position as per the amount percentage.

any thoughts

[Rahul Ganguli]

Hi Jim,

Can you explain in more details?
I not clear with the requirements.

Reagrds,
Rahul

[Jim]

Let me ask it two different ways.  Basically, I want a chart of percentages by month/year.  M/Y is X-Axis, Percentage is Y-Axis. 

I want each point on the graph to say not only the % values, but but also an annotation.  I understand markers and notes, but haven't been able to get those to work programatically through the query, having multiple markers/notes. That's question 1 - how do you assign a number of markers - one per data point on the graph?

The original question - let's say I have the structure:

MonthYear as integer
Percentage as float
Annotation as varchar(64)  (can = NULL)

I plot the chart using MonthYear and Percentage as value.  I want, instead of the value of Percentage shown, then field Annotation.

For example, if one datapoint is:

MonthYear= 201301
Percentage = .5
Annotation = 'Testing'

I should see a graph point for 201301, 50%, but it won't sway 50%, it will say 'Testing', but at the vertical position where 50% would be.


Does that make more sense?