BrianDP1977
Board Regular
- Joined
- Nov 5, 2005
- Messages
- 146
This will probably be easiest if I break my question into three parts.
1) Is it possible to pass a chart named ranges (I’m going to assume yes but have not yet tried it because I want to get the other two questions asked)?
2) In charts (a stacked bar chart to be specific), is there a way to define two separate ranges of information to be displayed for a single series. For example, the value for a series would typically be defined by the range $H$4:$H$28. Is it possible to define it so that it includes separate ranges such as $H$4:$H$5$ & $H$10:$H$11 & $H$20:$H$21?
3) If all the above is true (primarily the 2nd one), how would one go about defining a range within a range. As evidenced by the 2nd question, I currently have a large series of data in a column defined from H4 to H28 (named Data_All). This column of data is further subdivided into three other sections. Let’s say H4:H9 (named Data_1) is one section, H10:H19 (named Data_2) is another, and H20:28 (named Data_3) is the final one. The current chart displays all the data values from H4 to H28. I would like to create code that, when a button is toggled on, it will change from the chart showing all the data to one showing truncated data (is that the right word?) which displays the first two cells in each of the three sections of the entire data range (the resultant example of $H$4:$H$5$ & $H$10:$H$11 & $H$20:$H$21). The section sizes may change over time so the code would have to use dynamic names to search through specified ranges to determine the first two cells in the specified range. Is this possible?
1) Is it possible to pass a chart named ranges (I’m going to assume yes but have not yet tried it because I want to get the other two questions asked)?
2) In charts (a stacked bar chart to be specific), is there a way to define two separate ranges of information to be displayed for a single series. For example, the value for a series would typically be defined by the range $H$4:$H$28. Is it possible to define it so that it includes separate ranges such as $H$4:$H$5$ & $H$10:$H$11 & $H$20:$H$21?
3) If all the above is true (primarily the 2nd one), how would one go about defining a range within a range. As evidenced by the 2nd question, I currently have a large series of data in a column defined from H4 to H28 (named Data_All). This column of data is further subdivided into three other sections. Let’s say H4:H9 (named Data_1) is one section, H10:H19 (named Data_2) is another, and H20:28 (named Data_3) is the final one. The current chart displays all the data values from H4 to H28. I would like to create code that, when a button is toggled on, it will change from the chart showing all the data to one showing truncated data (is that the right word?) which displays the first two cells in each of the three sections of the entire data range (the resultant example of $H$4:$H$5$ & $H$10:$H$11 & $H$20:$H$21). The section sizes may change over time so the code would have to use dynamic names to search through specified ranges to determine the first two cells in the specified range. Is this possible?