Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro with line graph
Dear,
I have huge data with different headers. I want to plot a single line graph linked with a validation with the list of all the headers. The data in the line graph should reflect only the selected header among the list. For example, In the below example i should have a button command with the validation list of all the three headers below apples, oranges and grapes. By selecting oranges in the list, the line graph should pick only the data from colA and colC.. like wise ColA ColB ColC Cold Row1 Time Apples Oranges Grapes Row2 12:00 5 3 4 Row3 13:00 7 2 6 Row4 14:00 9 6 7 Row5 15:00 5 2 8 Row6 16:00 3 1 9 Please help me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro with line graph
Check out Jon Peltier's articles on dynamic charting:
http://peltiertech.com/Excel/Charts/Dynamics.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Sasikiran" wrote: Dear, I have huge data with different headers. I want to plot a single line graph linked with a validation with the list of all the headers. The data in the line graph should reflect only the selected header among the list. For example, In the below example i should have a button command with the validation list of all the three headers below apples, oranges and grapes. By selecting oranges in the list, the line graph should pick only the data from colA and colC.. like wise ColA ColB ColC Cold Row1 Time Apples Oranges Grapes Row2 12:00 5 3 4 Row3 13:00 7 2 6 Row4 14:00 9 6 7 Row5 15:00 5 2 8 Row6 16:00 3 1 9 Please help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
macro to print line graph from data in cells | Excel Discussion (Misc queries) |