billhealth
New Member
- Joined
- Nov 10, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I have an excel spreadsheet listing the values of crypto coins by date.
1/25 1/26 1/28 2/1
BTC 1600 1726 1659 1640
ETH 804 809 1240 936
CRO .21 .24 .22 .24
(NOT REAL DATA)
There are 65 coins i have been tracking for over a year. I have inserted charts to show the ranges.
However, 65 charts are quite messy! I would like to select the cell marked BTC or other coin and have one chart which will change based on the label in the cell.
I tried to use VBA but have been completely unsuccessful. If you have any suggestions, it would be very helpful. Thanks, BH
1/25 1/26 1/28 2/1
BTC 1600 1726 1659 1640
ETH 804 809 1240 936
CRO .21 .24 .22 .24
(NOT REAL DATA)
There are 65 coins i have been tracking for over a year. I have inserted charts to show the ranges.
However, 65 charts are quite messy! I would like to select the cell marked BTC or other coin and have one chart which will change based on the label in the cell.
I tried to use VBA but have been completely unsuccessful. If you have any suggestions, it would be very helpful. Thanks, BH