Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ish Ish is offline
external usenet poster
 
Posts: 2
Default Portions of lines being displayed in 2 diff formats simultaneously

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Portions of lines being displayed in 2 diff formats simultaneously

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.



"Ish" wrote:

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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Portions of lines being displayed in 2 diff formats simultaneously

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.
--
David Biddulph

"Ish" wrote in message
...
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lines displayed thru each row and column header JEV Excel Discussion (Misc queries) 1 April 24th 08 05:26 PM
how you make links between diff. cells on diff. work sheets NYC-MIKE Excel Worksheet Functions 3 February 11th 08 05:05 PM
Concaenate formula- text diff lines? LJoe Excel Worksheet Functions 9 June 13th 07 01:50 AM
Locking portions of a formula tiggatattoo Excel Worksheet Functions 2 June 5th 06 04:51 PM
Copying portions of data Wendy Clarkson Excel Discussion (Misc queries) 2 January 14th 05 11:51 PM


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"