Overlapping Graphs

If you want to over lap a bar graph with another, you can try formatting the series option in the graph where by you reduce the overlap gap

 

 

Get URL of a CELL

If you want to extract URL of a Cell, you can use it thru this macro

 

Function GetURL(cell As range, _
Optional default_value As Variant)
'Lists the Hyperlink Address for a Given Cell
'If cell does not contain a hyperlink, return default_value
If (cell.range("A1").Hyperlinks.Count <> 1) Then
GetURL = default_value
Else
GetURL = cell.range("A1").Hyperlinks(1).Address & "#" & cell.range("A1").Hyperlinks(1).SubAddress
End If
End Function

 

Source: http://howtouseexcel.net/how-to-extract-a-url-from-a-hyperlink-on-excel