AJP Excel InformationAJP Excel Information
ChartsVBAFun stuffForumsTipsLinksBooksWhat's newContactAboutSearchRSS Feed

 
 
 

Converting BMP image files to XY-Scatter chart

 
The two workbooks take a normal BMP image file and load it into Excel either as XY-scatter chart or directly into a worksheet.
XY-Scatter chart
The program reads the BMP file and then analyses the colour content.
As long as the image contains 56 or less unique the colours it will be plotted.
Depending on the image size you may need to increase the markers in order to fill in white space. Or reduce the size to stop overlapping.
Also adjusting the plot area size can reduce banding when the markers are too far apart.
The .zip file also contains a few bmp images to use for testing. 
This is the result:
Worksheet Cells
The process is similar to the xy-scatter chart.
This is the result:
 
These examples serve no particular use. More a case of because it was there!
If anybody find a real world use for either of the above please let me know.
 
 
Alternative links
   

Last updated 28th April 2007

 
 
  Home | Charts | VBA Code | Fun Stuff
Forum Examples | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2012 Andy Pope