I am trying to create a combo chart with 3 sets of data. The sets of data are called (1) total inquiries (2) inquires reviewed (3) percentage reviewed.
The primary axes I want to use total inquiries and inquiries reviewed (this is a bar chart). The secondary axes I want to use percentage reviewed (this is a line chart).
I have attached the spreadsheet which is mostly completed. I just can't figure out how to add the line chart for the last item. I am not even sure if this is possible. If any help is appreciated.
Thanks
P.S. My company is still using Excel 2000
Yes it's possible.
Select the chart and then extend the data range down to include the A5:F5.
The columns will move over slightly but you will not see any columns due to the very small values.
Select a column series and you the Up arrow to move through the chart elements. When you select the new series use CTRL+1 to display the Format dialog. From here you can set the series to the Secondary Axis.
Now you should see the columns infront of your existing 2 columns.
Select the series and change the chart type to Line.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks