Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
drawing chart only of select data
Hi All,
I am very new person to VBA world. I am given a task of drawing a XY Scatter Plot of data that are marked 1 ( or marked by checkbox) and showing the labels of those data. I started with some online help and auto-filter but I am stuck now. This is the kind of data I have: State Height Age Show Flag A 100 2 0 B 200 10 1 M 300 1 0 D 400 8 1 E 250 9 0 I used the code from http://support.microsoft.com/?kbid=213750 to add data lables to my plot but when I use auto-filter to show the rows with the "show flag=1", then the code snippet from Microsoft doesn't take the filtering into account and shows the labels from the unfiltered data. I am plotting height(x axis) versus Age(y-axis) with State name as data label. Any help would be appreciated. thank you Sri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use data from different worksheets to create a chart | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Why doesn't my chart update when underlying data changes? | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |