How to create a graph in microsoft office excelCreate a new excel
Rename the first sheet to DATA
Choose the type of data from insert tab in excel sheet
|choose the type of graph in excel|
type the following to the textbox " =DATA!$B$1:$E$7 " (where data is the sheet name, no need of double quotes)
A graph will be created, click on switch row/column
|Sales commodity wise graph|
The chart properties will be available in Layout tab
|Excel graph properties|
You can add title , data label , align it etc etc.....
DescriptionIf you are looking for sales commodity wise graph , then micro soft office excel package is a good option. you can choose what ever types of graphs. In addition to bar graph many options are there. you can easily switch from one graph to other one. you can switch the axis too, you can even customize where you want to keep your data series.
Java Graph API Documentation /