C
chris46521
I have created a pivot table and chart. The pivot chart consists o
three sets of data from the pivot table. Two of the data sets are line
and the third data set is displayed as columns. I made the third dat
set into columns by right clicking on the data series line an
selecting chart type. I change the chart type for that data set to
column and it worked great. The only problem is that when data i
refreshed in the associated pivot table, the entire chart turns int
columns with completely different formatting. Does anyone know how
can maintain the graph with the two lines and one column data set whe
I refresh the data? Thanks for your help
three sets of data from the pivot table. Two of the data sets are line
and the third data set is displayed as columns. I made the third dat
set into columns by right clicking on the data series line an
selecting chart type. I change the chart type for that data set to
column and it worked great. The only problem is that when data i
refreshed in the associated pivot table, the entire chart turns int
columns with completely different formatting. Does anyone know how
can maintain the graph with the two lines and one column data set whe
I refresh the data? Thanks for your help