MS Excel - Is it possible to create a graph from a series of data on demand and present it in a seperate window that can be closed after viewing? I have a spreadsheet wit approx 2000 SKU's on it and I want to be able to show stock & sales simply.
by 
phil_r
ANSWERS: 2
-
Maybe you'd like this idea even better: Store the data in MS Access and create a query (or multiple queries) to make temporary tables that you can export into a pre-defined Excel spreadsheet. Call in a Macro with the RunApp command: RunApp / Excel.exe "C:MyPathMyPathMyPathMySheet.xls" When the .xls file opens, have a Workbook.Open macro in the Excel file that formats your exported data, and a ChartSheet that displays exactly what you have just exported. The Access macro can also delete the temporary table, and your main data set remains pristine. So it's safer and way faster, because of Access' better ability to work with larger record sets. Quick, clean, secure -- and temporary.
-
In Excel 2003 and 2007, select any data in the worksheet, then go into the Data menu option and create a pivot table. Then you can add the headings and create graphs on the fly in a seperate sheet.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC