Hi All,
Trying to format a line chart based off of Actual, Forecast, and Budget data. I have an Actual/Forecast line, which I would then like to have half one color for Actual and half another color for forecast, based on I am in the year.
I'm having a difficult time figuring out how to do this. Looked online here Conditional Formatting of Excel Charts - Peltier Tech Blog but didn't have much luck, although the conditionally formatted line graph is similar to what I am looking for.
I'm not sure how I connect the changing data with the graph so that the color will change based on the updated month. Any help would be appreciated.
Thanks
Trying to format a line chart based off of Actual, Forecast, and Budget data. I have an Actual/Forecast line, which I would then like to have half one color for Actual and half another color for forecast, based on I am in the year.
I'm having a difficult time figuring out how to do this. Looked online here Conditional Formatting of Excel Charts - Peltier Tech Blog but didn't have much luck, although the conditionally formatted line graph is similar to what I am looking for.
I'm not sure how I connect the changing data with the graph so that the color will change based on the updated month. Any help would be appreciated.
Thanks