Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 18
Default Changing line appearance for future values

Thank you for the directions. After clicking once to select the line I moved
the mouse pointer between two markers and right-clicked to bring up the menu
that lets you format a point instead of the whole series.

"David Biddulph" wrote:

Click twice on the relevant data point, firstly to select the data series,
but then secondly to select the data point, to enable Format Data Point
instead of Format Data Series.
--
David Biddulph

"RhysPieces" wrote in message
...
The first suggestion seems to imply one can select individual segments on
a
line (e.g. a month) and format it manually. From what I see in Excel,
formatting is applied to the whole liine. How is it possible to select
line
segments?
Also, I tried the second series idea but it is inserted in the chart at
the
beginning of the year rather than at the beginnng month for the new
series.
What causes that?

"RhysPieces" wrote:

Using Excel 2007. Is it possible to change the appearance of a line in a
chart for values in the future (like projections)? I would like to go
from
solid to dashed and keep the same color and weight.




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
Changing text appearance Max Prophet Excel Discussion (Misc queries) 3 March 30th 07 03:18 PM
Count & Sum Consecutive (2x) appearance of Specific Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 2 February 5th 07 02:44 PM
Insert spreadsheet - without changing appearance? Lizardo Excel Discussion (Misc queries) 4 December 12th 06 04:14 PM
Changing the appearance of the cursor/pointer & size of tabs bjd1109 Excel Discussion (Misc queries) 0 February 7th 06 05:51 PM
How to format date as text without changing appearance? [email protected] Excel Discussion (Misc queries) 4 May 18th 05 09:25 AM


All times are GMT +1. The time now is 10:24 AM.

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

About Us

"It's about Microsoft Excel"