The Geek House

Posts Tagged ‘chart’

abap2xlsx – Business charts

by
1 Comment
abap2xlsx
In July 2010, SAP Mentor Ivan Femia released the first version of the open source project abap2xlsx that allowed ABAP developers to generate professional spreadsheets from scratch with all the advanced features that stand alone Excel editors provide like: style and cell data formats, drawings support, conditional formatting, formulas, and so on. This project has improved the user...
Read More »

Automate Excel charts building and moving to Power Point presentations

by
No Comment
Hi, Today we would like to present you yet another Excel add-in that we created for one our client. This is another implementation of the tool to build and transfer Excel charts into PowerPoint presentations. The tool is quite universal so you could easily adapt yourself to use it. The solution is quite simple and it uses at maximum the natural capabilities of Excel. So, imagine...
Read More »

Arrow charts in Excel

by
No Comment
Hi, Today we would like to present you another solution that we started to use in our company. This is a tool for automatically building ARROW CHARTS! After spending some time searching for ideas or similar tools in the Internet we found nothing that would perfectly fit our needs, thus, we created our own solution. To make the story short, this is how it works: The tool works...
Read More »

Excel: Load data from an external data file and create dynamic charts

by
No Comment
I would like to present you a project of mine that shows how it’s possible to load data into excel from an external data file and create dynamic charts. Very interesting is the possibility to upload data with a simple browsing window. (only 1 code line) Dim sFileName As Variant sFileName = Application.GetOpenFilename(“Text Files (*.txt), *.txt”)   ‘can...
Read More »

Charts in Excel automatically

by
No Comment
Hi, today we will present you one more small solution to simplify your life in working with Excel. This is an Excel add-in that will enable you to build charts based on one selected. Let me explain its use on an example. Assume that you have a huge table of data (say, some 50 000 rows). When you decide to build a chart based on this table of data you will probably want to build...
Read More »
%d bloggers like this: