Did a chart in the excel in data source is another sheet of D1: G1001 then abscissa in the chart shows, 1001, now I just want to in the chart shows: D1 G400 data, is I don't want to see on the chart from 401 lines of data, if you don't change the chart data source, how can you accomplish this requirement

In addition, there are more than 90 chart, I excel in data source take column take sheet is different, how can be modified at the same time, from the chart to 1001 rows instead of only 400 rows of data before

I am a technical white hope god can provide a simpler way to

Thank you thank you very much!

CodePudding user response:

Modify the data source should be very convenient, why not? More than 90 chart, don't need 1 second...

CodePudding user response:

Inquire of simple method I modify the data source is every one table and then modify the access right I feel particularly slow a figure a figure

CodePudding user response:

reference 1st floor Topc008 response:

modify the data source should be very convenient, why not? More than 90 chart, don't need 1 second...

Inquire of simple method I modify the data source is every one table and then modify the access right I feel particularly slow a figure a figure

CodePudding user response:

Such as:
ActiveChart. SetSourceData Source:=Sheets (" Sheet1 "). The Range (" A2: A20 ")

CodePudding user response:

reference 4 floor Topc008 response:

, such as:
ActiveChart. SetSourceData Source:=Sheets (" Sheet1 "). The Range (" A2: A20 ")

You inquire the overall code before seen for each attempt failed sheets is not the same sheet of what each different data sources is not too clear how to operate