3 Replies Latest reply on Sep 24, 2012 12:17 PM by Rik Ramsay

    Place Excel charts/graphs in InDesign

    vikojh

      Hi We need to put MS-Excel 2007 graphs in InDesign CS4.  Earlier we used to just copy and paste them. We have around 15 graphs that need to be put.

       

      However, now our client has asked us to recreate them in InDesign or Illustrator.  How do we do that?

        • 1. Re: Place Excel charts/graphs in InDesign
          BobLevine MVP & Adobe Community Professional

          Paste them into Illustrator. Tweak as needed and then place the resulting AI file in InDesign.

           

          Note: do not use anything other than solid fills in Excel for the objects in the chart to keep this easy.

           

          Bob

          • 2. Re: Place Excel charts/graphs in InDesign
            vikojh Level 1

            No they want them re-created in illustrator.

             

            Can an MS-EXCEL chart be recreated exactly the same way in Illustrator?

             

            The client had shared some Illustrator graphs with us. However, we did not find any data embedded within the graphs, thus, were unable to understand the approach to be followed while creating the graphs in Illustrator.  Does that mean that they too, were copy pasted from MS-Excel to Illustrator.  Further, we are unable to assign data labels to the graphs created.

            • 3. Re: Place Excel charts/graphs in InDesign
              Rik Ramsay Level 4

              vikojh wrote:

              No they want them re-created in illustrator.

               

              Can an MS-EXCEL chart be recreated exactly the same way in Illustrator?

               

              The client had shared some Illustrator graphs with us. However, we did not find any data embedded within the graphs, thus, were unable to understand the approach to be followed while creating the graphs in Illustrator.  Does that mean that they too, were copy pasted from MS-Excel to Illustrator.  Further, we are unable to assign data labels to the graphs created.

              More or less, but rarely exact. You would use the chart/graph tool in Illustrator. This allows you to add the data in to the chart and it can be modifed at any time. However, if you outline/expand the chart, it loses the connection to the data and is therefore a static chart.

               

              Maybe the charts supplied to you were outlined/expanded? See screenshot for the tool.

              AI_GraphTool.jpg