Seeker After
Member
Hello all,
Perhaps this topic is a bit obscure for my searches but I haven't found a thread touching on this particular problem. I hope I haven't broken any rules or placed this on the wrong thread, here it goes...
As seen in the thumbnail image from the Data tab I have two dynamic charts, gray is a copy of the blue, with identical data. When I re-range the chart, changing the number of data points to be displayed from the Control tab>Max Visible Rows the dynamic charts are supposed to, like the light blue chart in the image, fill the chart area.
Apart from adding one additional series, "PtHiLt", using the same named ranges on the gray chart I believe the two are identical and should behave the same however that is not the case. When a number of rows is selected from the Control tab>Max Visible Rows other than 100 the gray chart displays a gap at the Right of the chart area. It is this Gap that I'm trying to get away from. I'm not sure what I've done differently or how I'm getting the blue chart to function but any modification to it in its current state fails or on its copy, the gray chart. Any help would be a huge assistance, been stuck for a week now. Thanks.
View attachment 74419![74423 74423](https://chandoo.org/forum/data/attachments/74/74515-e662f04c33a6cc4f72ed05a84628f5d5.jpg)
Perhaps this topic is a bit obscure for my searches but I haven't found a thread touching on this particular problem. I hope I haven't broken any rules or placed this on the wrong thread, here it goes...
As seen in the thumbnail image from the Data tab I have two dynamic charts, gray is a copy of the blue, with identical data. When I re-range the chart, changing the number of data points to be displayed from the Control tab>Max Visible Rows the dynamic charts are supposed to, like the light blue chart in the image, fill the chart area.
Apart from adding one additional series, "PtHiLt", using the same named ranges on the gray chart I believe the two are identical and should behave the same however that is not the case. When a number of rows is selected from the Control tab>Max Visible Rows other than 100 the gray chart displays a gap at the Right of the chart area. It is this Gap that I'm trying to get away from. I'm not sure what I've done differently or how I'm getting the blue chart to function but any modification to it in its current state fails or on its copy, the gray chart. Any help would be a huge assistance, been stuck for a week now. Thanks.
View attachment 74419
![74423 74423](https://chandoo.org/forum/data/attachments/74/74515-e662f04c33a6cc4f72ed05a84628f5d5.jpg)
Attachments
Last edited: