Hi, I have a chart that gets it's data from a data table. The X-axis automatically updates as data is added to the table, but I have to manually set the range for the y axis initially when I set up each chart. Appreciate any help.
Hi, I have a chart that gets it's data from a data table. The X-axis automatically updates as data is added to the table, but I have to manually set the range for the y axis initially when I set up each chart. Appreciate any help.
The range should auto adjust also, but without seeing what you are working on it's hard to say what challenges you are facing.
If you right click on the Y-Axis and select Format Axis, check to see if the Range Bounds are set to Auto.
If not, maybe a sample workbook could help. Instructions in the "Yellow" banner at top to upload.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks