Updating links between excel and powerpoint Sex chat with english people
When the source data for your data-driven charts is available in Excel, you can create charts directly from the Excel application.
For more information about how to edit chart data, see Edit data in a chart.I have been given the job to update a powerpoint which has about 100 charts in it that link to a single (very large) excel spreadsheet. I took screen shots of the edit links box after I ran the macro to show you what I am seeing. I do it by going to excel, clicking on the chart, copying, then pasting it into the powerpoint slide. Screenshot: Edit Yours is showing Type: Excel Worksheet Without being able to get it to show me the same thing it's tricky to develop somethign to fix it.At present these links refer to an old version of the excel file in a specific file locations. If I were trying to do it I would use this logic: read the whole name into a whole String find the position of the open square bracket in whole String copy everything upto and including the square bracket into a new variable, start String find the position of the close square bracket in whole String copy the close square bracket and everything after it into end String then concatenate the parts with: whole String = start String & Excel File & end String You may have to play with Excel File to get it to just give you just the filename without the full path - possibly with yet another variable, say Excel File Short Good luck, and Merry Christmas.For a step-by-step guide on how to create a chart from your Excel data using think-cell, please consider the example from Introduction to charting.This is how the example chart data looks in Excel: To create a chart from Excel, select the desired data range in your Excel workbook, including series and category labels: The layout of your data must match the layout of think-cell’s internal datasheet: Column charts are usually created from data columns, whereas bar charts are created from data rows.