Graphing Line Chart using Code

**visualnewbie09** · 08-06-2014, 08:39 AM

I need help creating a macro that graphs a line chart with markers for the table I attached. I am new to visual basic and not sure how to achieve this. I need two separate graphs. One graph uses the data only for location 1 and other for only location 2. The y-axis is the average and the x-axis is the distance highlighted in blue. I only need the averages from distance 120 to 260. I highlighted the range for the averages in yellow for location 1 and in red for location 2. I will have more headers other than the example spreadsheet so I need it to graph as long as there are so many headers. I need the line width to be 1 pt and the marker width to be .75 pt. If someone could please help I would appreciate it.

**watersev** · 08-13-2014, 10:38 AM

hi visualnewbie09, if I understood everything correctly it should be what you are looking for. Please check attachment, run code "test" or press Run button on Sheet1 in left upper corner.

Marker size should be in range from 2 to 72. For now it is 2 points.

**visualnewbie09** · 08-13-2014, 10:54 AM

I need to change the locations to left and right how would I incorporate that into the code especially this line "Set c = .Find("Location " & i, , xlValues, xlWhole)"

**watersev** · 08-13-2014, 11:06 AM

please check attachment

**visualnewbie09** · 08-13-2014, 11:44 AM

How would I change it to work for this setup, but all in one graph.

**visualnewbie09** · 08-13-2014, 03:51 PM

Thank you watersev for the help

**watersev** · 08-13-2014, 04:12 PM

please check attachment

**visualnewbie09** · 08-13-2014, 04:24 PM

Thank you for the tremendous help!

Graphing Line Chart using Code

LinkBack

Thread Tools

Rate This Thread

Display

Graphing Line Chart using Code

Re: Graphing Line Chart using Code

Re: Graphing Line Chart using Code

Re: Graphing Line Chart using Code

Re: Graphing Line Chart using Code

Re: Graphing Line Chart using Code

Re: Graphing Line Chart using Code

Re: Graphing Line Chart using Code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Graphing/Formatting a Line Chart

Line Chart Not Graphing Data Correctly

VBA code to change pivot chart line on 12 charts

Graphing : Dynamic line chart axes

Code for creating line between two cells - Spaghetti chart

Bookmarks

Bookmarks

Posting Permissions