I have 2 scatter (may do a 3rd) charts that reference coordinates in 3D space.
I am referencing 3 tables as series'. Matal parts, Plastic parts, Fittings.
Becaues the scatter charts reference the same tables with the same items the onle difference being one chart refferences the X and Z columns and one refferences the Y and Z columns I would like to make both charts use the same format settings and display only one legend for both charts.
Is this even possible?
Sub Reputation() Dim Problem as Variant Dim Reputation as Integer For Each Problem in Forum.Threads If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1 Next Problem End Sub
Your signature is very clever but it took me a minute to realize it was not part of your question.
You cannot have a single legend for two charts.
I would make the first chart, then copy it. Now you have two charts with the same formatting. Then for the second chart, Chart Design > Select Data and adjust from the X to the Y data (or click the chart and drag the selection to change it).
But the data in the two charts is now different. Are you saying that you want a single legend that lists X, Y, and Z? I don't think that's going to be possible. You can't show data in a legend that is not in the chart. If you add the data but make it invisible, then the legend will also show it as invisible, which doesn't help you.
The other option is to manually craft a legend as an image after the formatting in your charts is settled.
We might have other ideas if you could attach as sample file.
The legend lists Metal parts, Plastic parts, etc. The X, Y & Z are used to place the points on the scatter plot.
I am thinking this might be a job for VBA. Make a 3rd chart that only shows the legend or maybe an active X object and have it linked to an on change comand to copy it's formatting and source ranges to the the other 2 charts.
I don't want to use images or anything static because A user styles/ colour pallets will change the charts but not the images, B) it is too easy to go wrong if any data changes.
If I get some spare time I will upload a dummy sample. I can't use the actual files because it involves aircraft data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks