Line chart with a multiple colored line

[Nesma.aboulfetouh]

Hi,


i have a product's daily sales line chart that i want to format so that the line would be made of multiple colors as follows: one week would have a color x and the following week would have a color y and then x and y again and so on...


ur help is very much appreciated

 

[Luke M]

You'd have to make it as multiple series, each color being a separate line, and just joining them end to end. If you're just alternating colors, you could do it with 2 series, and use some empty cells to cause gaps (tools - options, chart, plot empty cells as gaps)

 

[prasaddn]

Hi,


You can have data in two columns and try to plot as two series..


Regards,

Prasad