chart data from multiple sheets excel. Just create a column for each sheet, with a 3d reference to the appropriate. Sometimes while dealing with hierarchical data we need to combine two or more various chart types into a single chart for better visualization and analysis. How to Create a Chart …