Hi,
Please suggest me how I create 3D chart in Excel for the sales data. I have data in 3 columns, Column A contains Agent name, column B contains Sales amount and column C contains Month.
thanks
Hi,
Please suggest me how I create 3D chart in Excel for the sales data. I have data in 3 columns, Column A contains Agent name, column B contains Sales amount and column C contains Month.
thanks
Preapre first Pivot table using months as columns headers, agents as rows headers and sum of sales amount in data.
Then draw your 3D graph from this Pivot table.
Best Regards,
Kaper
If you provide a sample of data (paste the data into a code block; I won't open a workbook), I can show a few non-3D chart approaches which would be easier to read than any 3D chart you could draw in Excel.
Jon Peltier
http://PeltierTech.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks