Hi everyone.
I need to show 4 data sets on one chart. Ideally I'd like to have a column showing 2 data sets (both are percentages of the same item) and 2 lines. One for a trend and 1 for a different data set.
Has anyone done this.
I use excel 2003 btw....
Create a stacked column on all 4 data series.
Select the series that is to be a line chart and change it's line type.
The change the series to the secondary axis via the Format dialog.
Do not use the built-in custom chart types.
Perfect answer to the task I've just set myself
Works a treat.
FYI Plotting pupils scores across a series of tests using the line. Wil have stacked columns in the background indicating the grading bands.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks