Need to know how to insert additional data into a bar & trendline graph and designate the new data to be one of the "bars" instead of the default to trendline.
Need to know how to insert additional data into a bar & trendline graph and designate the new data to be one of the "bars" instead of the default to trendline.
If I were in your shoes, though, I'd probably select the entire chart,
change it to a column graph (Chart/Chart Type), then right-click on just
the data series I want to be a line and go to Chart Type. Change that
type to a line graph. But because I've selected only one data series,
only that data series changes into the line.
