Thank you for taking the time to review this thread. I searched for threads that match my problem and could not find anything.
I am trying to setup a chart that draws data from a spreadsheet that has multiple columns. I want to put column A in every chart. The next step is to add columns from the spreadsheet, in one case the two columns are right beside the "A" column- "B and C". In other cases the additional columns will be "D and E", "F and G", etc.
I activate the sub by clicking on a column header on the spreadsheet. In the code below I'm trying to use the "Union" function but to no avail. I can't even get the sub to chart columns without using the "Union" function. The line that is causing me the grief is prefixed by "****".
The spreadsheet that holds the chart and the data source is attached.
I am open to any solution that will create the desired chart. I apologize for the sloppy coding, I'm not that well versed in VBA codi
Thank you for taking the time to read my issue.
Bookmarks