Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|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
add comment

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.

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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