Please see attached.
The graph which i have currently created shows the data of columns C-H, which show the bars.
I want to add column I onto the graph but I want to show that as a line rather than a bar.
Can you help me?
Many thanks!!!
Please see attached.
The graph which i have currently created shows the data of columns C-H, which show the bars.
I want to add column I onto the graph but I want to show that as a line rather than a bar.
Can you help me?
Many thanks!!!
Extend the chart data range to include column I. This will add another section to the stacked columns.
Right click new section and change chart type to Line.
Having done that the Average line does not make much sense as only the first series in the stack is in a position to be compared to it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks