Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

how to remove border of excel chart?

Enthusiast ,
May 11, 2018 May 11, 2018

Q_Id_1.png

I placed a MS Word file on Id.

On the right-hand page, there are grey borders around the excel charts.

How can I remove them?

No borders in the chart on the left-hand page.

4.6K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 11, 2018 May 11, 2018

Those borders originate in Excel (or Word). Either open the original file and remove them there or gently crop the image on all four sides in InDesign by slightly reducing the size of the graphic frame they are each sitting in.

~Barb

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 12, 2018 May 12, 2018

The "chart" on the left was probably not created as an Excel chart. It was drawn in Word, PowerPoint. Excel, or Illustrator, but it was not done with the Chart feature. That's why there is no border as a default. You can add a border to any picture using Word.

  1. Excel borders in Excel:
    Change the Chart Border from the default of Automatic to No line.
  2. Excel borders in Word:
    After the chart is in Word, you can still remove the border from the Excel chart
    This is easiest since you have several
  3. Excel borders in InDesign
    Crop as Barb said.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
May 15, 2018 May 15, 2018

Thank you very much.

It was helpful.

Hosun Kang

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 21, 2022 Oct 21, 2022
LATEST

I am having the same issue. All my charts were created in Excel.  In Excel, I have ensured NO LINE is chosen on all.  However, some still show a border, others do not.  They are exactly the same.  I will crop as indicated as a work around, but is there anyway this bug can be repaired?

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
May 15, 2018 May 15, 2018

Thank you very much.

It was helpful.

Hosun Kang

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines