Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
zibel_boy
 
Posts: n/a
Default how to create a multiple-color trendline in excel?

If I have a graph with multiple trendlines, and I want to have a certain
trendline in a different color from a certain point, how do I do it without
changing the color of the entire trendline?
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

I don't think you can directly, since the trendline is a single object,
so you cannot format just a segment of it.

You could fake it by getting the coefficients of the trendline (if from
the chart, be sure to display in scientific notation with 14 decimal
places to avoid rounding) then remove the trendline from the chart
(because it will always appear on top of everything else) and manually
replot the trendline from cells as two different series divided at your
desired breakpoint.

Jerry

zibel_boy wrote:

If I have a graph with multiple trendlines, and I want to have a certain
trendline in a different color from a certain point, how do I do it without
changing the color of the entire trendline?


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
How do i auto create multiple files from 1 with multiple sheets Kathy Excel Worksheet Functions 0 July 26th 05 01:23 AM
how can i open multiple excel sheets separately srinu Excel Discussion (Misc queries) 1 July 8th 05 04:38 PM
Can you create a performance dashboard using Excel? sbtrooper Excel Discussion (Misc queries) 0 February 16th 05 05:05 PM
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 08:51 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 07:53 AM.

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"