Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Chart with x and y axis
hey!!
i would like to do a chart in excel with the chance to put a range of values correspoding to the y axis and another range to the x assis. the chart has to be a line type. do u have any idea of the code for that on VBA? i really appreciate your help!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Chart with x and y axis
Try recording a macro to do what you want. If you have questions on how to
clean it up, come back. -- HTH, Barb Reinhardt "Xaraam" wrote: hey!! i would like to do a chart in excel with the chance to put a range of values correspoding to the y axis and another range to the x assis. the chart has to be a line type. do u have any idea of the code for that on VBA? i really appreciate your help!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Chart with x and y axis
hey Barb,
the thing is i have to do that not just for one excel sheet but for more than 100, where the y and x axis values are not of the some amount on each sheet. It can varies from 5000 up to 15000 lines. So probably the best would be VBA code doing a range and then a way to insert those values into the y and x axis. "Barb Reinhardt" wrote: Try recording a macro to do what you want. If you have questions on how to clean it up, come back. -- HTH, Barb Reinhardt "Xaraam" wrote: hey!! i would like to do a chart in excel with the chance to put a range of values correspoding to the y axis and another range to the x assis. the chart has to be a line type. do u have any idea of the code for that on VBA? i really appreciate your help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to chaneg axis text on a chart? | Charts and Charting in Excel | |||
Finding second data point on primary axis of two axis chart | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |