Chart Problem
I have a data table that shows weekdays in the left column and values in the
next two columns, the data range is called 'Month'. I have a macro that creates a Chart, but the category axis shows all days in the month when run, even though there are not shown in the data table. How can I stop Excel autofilling a chart with dates that I don't want and that are not included in the data table? Thank you. |
Chart Problem
No worries, i've got it sorted
"LaDdIe" wrote: I have a data table that shows weekdays in the left column and values in the next two columns, the data range is called 'Month'. I have a macro that creates a Chart, but the category axis shows all days in the month when run, even though there are not shown in the data table. How can I stop Excel autofilling a chart with dates that I don't want and that are not included in the data table? Thank you. |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com