LinkBack URL
About LinkBacks
How can I merge series that have identical names on a line graph?
Ex.
ABC:5
BBC:4
CBC:3
ABC:10
DBC:5
Currently the line graph just makes two sets for "ABC". How can I make it one?
How can I merge series that have identical names on a line graph?
Ex.
ABC:5
BBC:4
CBC:3
ABC:10
DBC:5
Currently the line graph just makes two sets for "ABC". How can I make it one?
You need a macro to merge the data on the worksheet table...How it will work exactly depends on your data layout and the specific series names but it's fairly simple.
Elegant Simplicity............. Not Always
formula or pivot table are other ways to create a summary data set for you chart.
Charts by themselves do no summarize data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks