Add a 'Target Line' at Column Chart

[Zoro Swordsman]

Hi, I want to set a 'target line' which is as shown in the figure above in order to see which country achieve or reach the target which is the amount of 10,000,000. How can I draw a straight line at the value of 10,000,000? I'm using Google Column Chart.. Thanks..

[asgallant]

You have to switch to a ComboChart.  Use the "series" option to set your data series to "bars" type and add a "line" series with the value of 10000000 at each point.

[Zoro Swordsman]

But if I use ComboChart then how I suppose to make the 'line' draw from 0 until the end? I mean based on the minimum and maximum value of x-axis exactly same like the diagram shown.. Thanks..

[asgallant]

Is your "year" axis based on strings or numbers?

[Zoro Swordsman]

Actually my data is not like shown in the figure. My y-axis value should be 'Percentage' while x-axis while be 'Departments. So the value of x-axis is 'string'. So,how I suppose to write the code for that single straight line? Can some me an example of source code? Thanks.

On Tuesday, April 23, 2013 2:15:25 PM UTC+8, Zoro Swordsman wrote:

[asgallant]

With a string-type axis, you cannot get an edge-to-edge line like that, unfortunately.

[Zoro Swordsman]

Okay.. Thank.. Highly appreciate your help..

On Tuesday, April 23, 2013 2:15:25 PM UTC+8, Zoro Swordsman wrote: