knighttrader
New Member
- Joined
- Apr 3, 2010
- Messages
- 21
- Office Version
- 2021
- Platform
- MacOS
Hi
I have a chart (Chart 1) using daily P&L figures for 365 days. However, I want the horizontal access to grow as each days data is added.
Example A is easy to set up to cover the full 365 days from day 1, but as of 4th March I want the chart to look like Example B based on 12 days data.
The chart has two series
1 = Column P
2 = Column Q
Can anyone help with the VBA so that the Y values for series 1 & 2 grow each day based on the data from Row 3 to the last row with a date in Col. O?
Many thanks
Neil
I have a chart (Chart 1) using daily P&L figures for 365 days. However, I want the horizontal access to grow as each days data is added.
Example A is easy to set up to cover the full 365 days from day 1, but as of 4th March I want the chart to look like Example B based on 12 days data.
The chart has two series
1 = Column P
2 = Column Q
Can anyone help with the VBA so that the Y values for series 1 & 2 grow each day based on the data from Row 3 to the last row with a date in Col. O?
Many thanks
Neil