Hi,
I have 2 seperate tables (both on the same sheet). Within these tables are percentages scored by different teams. What I want is to create a chart that will show 2 lines allowing me to compare both sheets.
Currently, I'm creating a new table and copying and pasting the 2 different rows from the tables and creating a chart from this.
I was wondering if there is a way to create a chart without having to create a new table? Or does excel require uninterupted data in order to make a chart?
I think it would be better if you created a set of data purely for charting.
This would be based on the selection of 2 teams. You would use formula to determine which set of data from each table was displayed.
If you need more help post an example of your data tables and chart.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks