Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting data points in a scatter chart | Excel Discussion (Misc queries) | |||
Selecting an Embedded Chart | Charts and Charting in Excel | |||
Why is excel 2007 slow when selecting chart data from the formula | Charts and Charting in Excel | |||
Selecting many specific columns for a chart | Charts and Charting in Excel | |||
Selecting data from different cells for a chart | Charts and Charting in Excel |