Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating multiple line charts
Hello. I am trying to make multiple charts with a large worksheet. It would need to be auto update of over 100 data sets. Is there a simple way to do this without making each and every chart :( Here is the type of data: x-axis is static (column A) y axis is dynamic - data set1 col B2 - B?? - data set1 col C2 - C?? - data set1 col D2 - D?? - etc auto min/max values Data Set 1 ========== Chart title = $A$1 + B1; Series Name = B1; Please let me know there is an easier way. btw, I have no experience using macros. Help appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating multiple charts | Charts and Charting in Excel | |||
Creating line charts | Charts and Charting in Excel | |||
creating mixed dashed and solid line charts | Charts and Charting in Excel | |||
Creating multiple charts | Charts and Charting in Excel | |||
creating multiple bar charts | Excel Worksheet Functions |