Help?


 
Post new topic Reply to topic
   ArchitectureWeek DesignCommunity Forum Index » PowerCADD Discussion
View previous topic :: View next topic  
Author Message
Matt



Joined: 13 Apr 2004
Posts: 525
Location: Sterling, Virginia

PostPosted: Sat Oct 24, 2009 8:02 am    Post subject: Help? Reply with quoteFind all posts by Matt

http://www.areforum.org/forums/showthread.php?t=180498

I have an XL spreadsheet with 6600 data points in it. I can do a scatterplot and copy and paste it into PowerCADD. I'm not much good with XL charting. Since I want to draw the vertical and horizontal axis to the same scale in my final chart, I have to stretch the output from XL. This makes the data-point objects oblong in PowerCADD. I don't like this. I don't want to manually replace 6600 ovals with circles. They are not symbols in PowerCADD so I can't do a global replace.

I'm attaching a closeup. Anybody got any suggestions? XL will only let me choose circles, squares, or diamonds, filled or unfilled.

Thanks.



huh.jpg


 

 Filesize:  500.76 KB
 Filename:  huh.jpg
 Viewed:  20 Time(s)
Back to top
View user's profileSend private message    share:   blogger     del.icio.us     digg     slashdot    
Derek



Joined: 13 Apr 2004
Posts: 598
Location: Melbourne, Australia

PostPosted: Sat Oct 24, 2009 3:38 pm    Post subject: Reply with quoteFind all posts by Derek

You can use any image as the markers in XL:
http://peltiertech.com/Excel/ChartsHowTo/CustomMarkers.html

Another thing is to, while still in XL, drag the aspect ratio of the chart to something like the final output you desire. I think you're doomed once you've converted the chart to an image.

The attachment below shows how you can use these techniques. Both of these charts had their aspect ratios adjusted in XL then copied and pasted into PowerCADD. No further changes were made except for re-sizing them in PowerCADD while constraining the aspect ratios.

Derek



Example.jpg


 

 Filesize:  43.76 KB
 Filename:  Example.jpg
 Viewed:  22 Time(s)

_________________
Tool Palette Guide
PowerCADD Preference Utility
Back to top
View user's profileSend private messageAIM Address    share:   blogger     del.icio.us     digg     slashdot    
Display posts from previous:   
Post new topic Reply to topic
   ArchitectureWeek DesignCommunity Forum Index » PowerCADD Discussion Page 1 of 1

 




Latest Posts   ·   Blogs   ·   Jobs Board   ·   Classifieds   ·   User Galleries   ·   Scrapbook   ·   Open 3D Gallery
 Architecture Search   by name of Building, Architect, or Place:  
Buildings     Architects     Types & Styles     Places     Models     GB Image Index     ArchWeek Library
Professional Directory   Web Directory   Competitions   Conferences   Events & Exhibits     Products     Media Kit
DesignCommunity   ·   ArchitectureWeek   ·   Great Buildings   ·   Archiplanet   ·   Books   ·   Free 3D   ·   Search
Special thanks to our sustaining subscribers Building Design UK, Building Design News UK, and Building Design Tenders UK.
© 2004-2009 Artifice, Inc. · Powered by phpBB © 2001, 2002 phpBB Group · Thème myApple v2.0.1 créé par myTemplate