One includes all 150 investments and the other one contains only 6. I created two XY Scatter Plot charts with the information you previously mentioned and they look nice. Is there a line of code that I can change to make the chart a pivot chart? Or is there a way to just make a Pivot Chart an XY Scatter Plot chart? The code you provided is excellent for initially making the chart, but the flexibility of changing investments is really want I am looking for with the added benefit of keeping it basic for my partners. It is also very easy for my partners to play with. The chart is always formatted correctly and looks very nice. It is very convenient to change the investment choices very quickly to make the comparisons I need. and the chart will redraw in a couple a seconds. I will go in and pick different investments (from within the chart by placing a check mark next to the investment) from different fund families or asset classes, etc. They are both line charts to graph returns over different time periods and daily ranking numbers. I have a couple other Pivot Charts in my workbook and they work wonderfully (I think it is pure luck that I got them to work however).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |