Hi All,
I humbly seek help to generate any type of chart just to demonstrate the information as below:-
customer,sales & year.
Pls take a look at my file for easy understanding. Thanks in advance
Hi All,
I humbly seek help to generate any type of chart just to demonstrate the information as below:-
customer,sales & year.
Pls take a look at my file for easy understanding. Thanks in advance
Last edited by seanyeap; 11-06-2008 at 03:53 AM.
Hi,
Change the format of your data to look like this:
customer 2007 2008
A 1000 6000
B 2000 7000
C 3000 8000
D 4000 9000
E 5000 10000
Then select the data and press F11 to generate the chart.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hi Sweep,
Thanks for your prompt reply, I followed your step and it is amazing. managed to created the chart, however, it looks very untidy and confussing. Pls take a look at my attached file. Thanks a million.
Try using a Line chart and plot months on the X axis with a line for each company.
Hopefully this is only test data
Hi Andy,
Hope you dont mind to elaborate further. I clicked chart type to Line then everthing went wrong.
Hi Andy,
I have used your sample to manipulate mine and it looks great,thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks