Sectioning a single plotted line into multiple colors

F

fish

Hi, I'm trying to plot a column of data values and I need to designat
certain sections of this data with a different color on the line. I
this possible? How can I do this? Thanks
 
T

Tushar Mehta

Suppose your data are in A1:A20 and you want A11:A20 to be a different
color from the first part of the range.

Move A11:A20 to B11:B20. Plot A1:B20 as two columnar series.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracked changes by multiple people modified to one 0
Non Linear Scatter plot, need to find y value 3
Plotting Graph with dynamic table 3
trendline in scatter plot 3
Charts When There Are No Data Values Sometimes ? 1
adding trendline to plots from multiple series 1
Match table shading (color) to Visio color/Transparency 1
Data points in chart incorrect 0

Top