Selecting row data for chart - Not sure what I did right
I wrote a pretty simple VBA program that sets rowhieght to zero for dat
rows that I want to hide in a bar chart. So if there are ten rows o data and I only want to show certain bars in the chart, I set th rowheight of the rows to zero and the chart redraws with only five bar instead of ten. OK so far. I noticed that if I do data-sort of th rows, the chart is messed up (all the spaces for the bars are installe in the chart, but the bars appear collected on one side. If I add dummy action such as copying dummy data from one cell to another, th chart is ok again. I am wondering if this business of setting th rowheight to zero to make bars disappear from the chart is a smart wa to accomplish what I want. If I invest any more time in thi application, I fear I may paint myself into a corner with it. An suggestions about how to accomplish this without the rowheight trick -- Message posted from http://www.ExcelForum.com |
Selecting row data for chart - Not sure what I did right
Thanks much. I'll try to abuse and see if I run into trouble. Many
thanks. --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 03:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com