Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
how can i open multiple excel sheets separately | Excel Discussion (Misc queries) | |||
Can you create a performance dashboard using Excel? | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |