Portions of lines being displayed in 2 diff formats simultaneously

I

Ish

Can portions of lines be displayed in 2 diff formats simultaneously in the
same graph? For example, can I have one graphed data line be displayed as a
solid line from months Jan thru April with months May through Dec being
displayed as a dashed line?
 
S

Shane Devenshire

Hi,

Yes. One of the ways is to do it manually, select the line on the chart and
then single click one of the segements you want formatted differently, this
is a data point. Choose Format, Selected Data Point, and on the Patterns tab
change the line properties. Repeat this for each of the data points.
 
D

David Biddulph

You can use Format Data Point, rather than Format Data Series, but if there
are many points in the range you'll be better splitting the line into 2
series.
 

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

Specify columns to add for months MTD Diff 3
Graph Manipulation 2
LINE CHARTS 1
Pivot Table Filter values 5
Displaying dashed or dotted lines correctly in logarithmic scale? 2
Show number in thouands using Formats 7
How can I transfer a required data from sheet 1 to sheet 2 automat 6
Variance Calculations 2

Top