1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

how can I change the color of lines related to future speculations to highlight them from what has already happened?

Our take

To enhance your graduation thesis and clearly differentiate future speculations from historical data, you can customize the color of specific segments in your chart. Most spreadsheet software allows you to select individual data series or points, enabling you to highlight future forecasts distinctively. By changing the color of these lines, you effectively guide your audience's attention, making your analysis of the company's index evolution more intuitive. This visual distinction not only improves clarity but also emphasizes the importance of your future predictions.

My graduation thesis will show the evolution of a certain index of a company, and also a forecast of how it will behave in the future. I would like to know if there is a way to change only specific segments of lines in a single chart.

submitted by /u/One-Lettuce-1404
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#rows.com#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#chart#graduation thesis#index#lines#future speculations#forecast#chart customization#evolution#color change#segments#company analysis#behavior#specific segments#data trends#data visualization#time series