Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Alot of chart in vb
Hello! I am making a macro that creats a report. The report is presented as a
new worksheet that my macro creates. The input data for the report can be found in the same workbook as the report. I am basically making alot of different charts (as well as some tables). In order to keep it flexible for the user I am not refering dierctly to cells. Instead I use variables to keep track of where everthing is (the data is identified by the title of the columns e.g. under the column "Market value" all market values are found etc.). Now I am making alot of charts. Some of these charts share some basic setups e.g. gridlines, size, type of chart, types of values on x-axis etc. However they also differ in many respects e.g. the number lines, the unit of measurement on the y-axis. If I am forced to have code for all the charts it is going to be a very long code. I was wondering if there is any convenient way of utilizing the fact that they share some charachteristics. I am not very good at neither Excel nor visual basic so I really dont know if it is possible nor if it desirable. If anyone has any clue regarding this subject I would be most greatful for your opinions. Thank you all! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |