![]() To ensure a continuous line the series must overlap, hence row 16 above has the same value in both columns D and E. The #N/A values aren’t plotted and that allows the lines underneath to show through where appropriate. ![]() This requires your source data to be set up with each series in its own column, like so: They are sitting on top of one another to give the appearance of a single line. The chart below contains 3 lines red, yellow and green. The second option for Excel multi-colored line charts is to use multiple series one for each color. Option 2: Multi-colored line chart with multiple series ![]() It really depends if you plan to update your chart with new data or not. Which means you can’t set values above or below a threshold with a specific color, and this makes updating the gradient stops for new data a (potentially) manual task. The limitation with the gradient is that it’s based on percentages, as opposed to absolute values. In the Format menu (bucket icon) for the line, choose ‘Gradient Fill’:Īdjust the gradient stops, adding and removing stops as required with the +/- icons to the right of the gradient bar. With the line selected press CTRL+1 to open the Format Data Series Pane. This is the simplest as it only requires a single series: The first is to use a gradient fill on the line. ![]() ![]() Option 1: Multi-colored line chart with Gradient Fill
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |