Posts by handzsolo

    excellent, didnt realise you could change chart type for each series. Is there a way of of making the line go across the whole chart though? I'll give a better description of what im trying to do.....


    X-axis has company departments on while Y-axis is money(£). I want a line going accross the chart which shows the target £. If i put the value in as a series it only shows up next to the first department. I think that explains it better!


    Regards


    Phil Adams

    I need to add a target value line into some graphs but do not know how. Ive got a series of values that are placed in a standard column graph (5 values in the spreadsheet) and want to add a line into the graph based on a single value from the spreadsheet (acting as a target value). If this makes any sense then help would be much appreciated!


    Cheers


    Phil