4 replies to this topic

[MrEmMak]

Looks like this



Should look like this




The bottom portion was created in Excel, then copied and pasted into arcmap. You'll notice the border on the right side of the page is not printing. On other pages that I didn't show here, the green cells in excel will print with no color. Basically, when I export map, it's not including some of the excel data and it seems to randomly pick and choose the things it does and doesn't want to print.

Does anyone have any experience with this?


Thanks,


Bob in Green Bay

[Jimbo]

I want to go off topic for a second & I understand that most Americans do not know this but before posting the Federal Highway System Symbol you will need to know that you should colour it according to your standards & that means that the background of Highway 8 should be black & not white. Otherwise you are indicating that Highway 8 is Nova Scotia Trunk Highway 8. As far as the image did you do a preview of it before exporting it. And did you check your page margins?

[ELeFevre]

The bottom portion was created in Excel, then copied and pasted into arcmap. You'll notice the border on the right side of the page is not printing. On other pages that I didn't show here, the green cells in excel will print with no color. Basically, when I export map, it's not including some of the excel data and it seems to randomly pick and choose the things it does and doesn't want to print.

Hi Bob,
Welcome to the forum. When you pasted the excel data in Arcmap did you use Edit Menu> Paste Special>Picture? Using this method will copy and paste any clipboard content into Arcmap as an image. This should take care of the issue. Also make sure the data-frame is within the page extents. If the data-frame is outside of the printable area, it's going to crop at the edge of the page.

Erin

[jrat]

I want to go off topic for a second & I understand that most Americans do not know this but before posting the Federal Highway System Symbol you will need to know that you should colour it according to your standards & that means that the background of Highway 8 should be black & not white. Otherwise you are indicating that Highway 8 is Nova Scotia Trunk Highway 8. As far as the image did you do a preview of it before exporting it. And did you check your page margins?

When you say background you mean the white rectangle right? You are correct. MUTCD standard is black letters white shield and black background.

[NoDaker]

Instead of doing a copy-paste from Excel, have you looked at embedding the Excel spreadsheet as an object in the layout? In layout view, click Insert > Object > Create from File, then you can browse to the spreadsheet that you already created and it should preserve the formatting.