up vote 1 down vote favorite
share [g+] share [fb]

I've run into an issue with scatter plots in Excel. For whatever reason, Excel is distorting the appearance of markers on the plot, such that markers within the same series do not look the same. For example, in a series with circular markers, some of the markers appear as ellipses, some appear as smaller circles, etc.

enter image description here

Does anyone know why Excel is doing this? Better yet, any ideas how to stop this? For reference, I'm copying these graphs into Adobe Illustrator to create graphics for a print application.

link|improve this question
It may have to do with how the image gets rescaled. Are you changing the size of the resulting image at all? – Chris Nava Aug 9 '11 at 16:50
The chart in the image was rescaled. However, I did a few tests, and the same phenomena occurs regardless of rescaling or applying chart styles. – Excellll Aug 9 '11 at 17:35
feedback

1 Answer

up vote 1 down vote accepted

Just a guess: Try saving as (exporting to) to a PDF or other print format then copy the image from that.

link|improve this answer
Interestingly, the markers come out uniform in the PDF. However, the export reversed the direction of arrows on the axes (not shown above, sorry). Nonetheless, this actually made the graph easier to manipulate in Illustrator, and the arrow issue was easily fixed. Thanks! +1 – Excellll Aug 9 '11 at 20:26
I should also mention that it works much better to just open the PDF in Illustrator rather than copying the chart image from Acrobat over to Illustrator. – Excellll Aug 9 '11 at 20:32
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.