Power Point Think Cell to Excel chart

Brass Contributor

Hello,

 

Can anyone suggest some ideas as to how to change the attached graph generated via Think Cell in Power Point to an Excel Chart? As close as possible. Appreciate maybe the last couple of columns may need to be added on manually, but who knows, someone may know how to do this.

 

Many thanks in advance for the help!

1 Reply

@JennySommet 

Unfortunately, directly converting a Think Cell chart in PowerPoint to an Excel chart isn't possible. There's no native functionality within either software to achieve this seamlessly. However, you can achieve a similar outcome using different approaches:

1. Manual Recreation:

  • Analyze the Think Cell chart: Identify the chart type, data points, axes labels, formatting, and any other relevant details.
  • Create a new chart in Excel: Choose the closest matching chart type in Excel and customize it to replicate the Think Cell chart as closely as possible.
  • Manually enter data: Enter the data points from the Think Cell chart into the corresponding cells in Excel.
  • Format the chart: Adjust the axes labels, colors, fonts, and other formatting options to match the Think Cell chart.

This approach requires manual effort but allows you to recreate the chart with precise control over its elements.

2. Export Think Cell data:

  • Think Cell offers data export options: Depending on your specific version, you might be able to export the data underlying the Think Cell chart to a format like CSV or Excel.
  • Import data into Excel: Import the exported data into a new Excel sheet.
  • Create a chart from imported data: Choose the desired chart type and use the imported data to generate a new chart in Excel.

This approach saves time on data entry but might require additional formatting to match the visual style of the Think Cell chart.

3. Consider alternative tools:

  • Third-party add-ins: Some third-party add-ins for Excel claim to offer functionalities for converting charts from other software, including Think Cell.
  • Online conversion tools: Limited online tools might exist that attempt to convert charts between different formats, but their accuracy and reliability can vary.

These options involve exploring external solutions with their own potential limitations and costs.

Additional Tips:

  • If you have access to the original data used to create the Think Cell chart, it's generally easier to use that data directly in Excel to create a new chart.
  • When recreating the chart manually, pay close attention to details like data labels, legend entries, and gridlines to ensure a close resemblance to the original.

While there's no direct conversion method, these approaches should help you achieve a similar result by either manually recreating the chart in Excel or utilizing the underlying data for a new chart creation.