chart graph vba excel

  1. twinetwstr

    Chart Range quoting problem

    This should be so simple! I am building a subroutine to create a chart based on a selected group of cells in separated columns. If I hard-code the statement as >>> Set ChrtRange = Range("B5:B8,K5:K8") I can plug ChrtRange into >>> CH.Chart.SetSourceData Source:=ChrtRange...
  2. W

    Creating a chart/graph in Excel using VBA?

    I have been struggling with this problem for days now, as I have been trying to teach myself how to write something in VBA. Thanks in advance for your help! I am trying to create a graph in Excel 2007 that is taken from data that is exported each day. A couple of nuances: (i) while columns...

Some videos you may like

This Week's Hot Topics