3 dimensional graph needed

[Rinki]

Hi everyone,

i have a typical situation where I am looking to plot my data attached herewith a 3 d graph which would represent sale performance of the reps year over year in a way which is looking good and easy to understand.

Please let me know the best options.

 

[Hui]

Why not something simple like:

 

[Rinki]

Well hui thanks but this was rejected stating it was complicated to interpret by my boss.

 

[Chihiro]

To do 3rd dimension, you'd need size (like Bubble Chart), but it'd be far too difficult to read and does not really tell a story in your data sample. I agree with Hui's approach.

Just do Pivot Table and add 2 slicers for quick analysis.

 

[Hui]

Or you could use a Bubble chart?

 

[Chihiro]

Here's stacked bar chart approach (used Pivot to reorganize data).

 

[Hui]

I would use one of teh following if it was my Data
It depends if you are highlighting the Year or Person
see attached file:

Or as Chiriro said, You can convert either to a cummulative chart if that is what you are highlighting

 

[Rinki]

Hi Chihiro/hui, i had tried all this except bubble chart options which looks interesting but the requirement is of line chart where sales rep is expected to be on y axis and calendar year over x axis and then $ value as output line chart.

 

[Hui]

You can't display Value as a Line using the Year and Name as X/Y Fields?

 

[Rinki]

is it possible in bar graph for the output that i m looking for

 

[Hui]

Like

 

[Hui]

My last two guesses:

 

[Chihiro]

Is your boss opposed to something like this? Simple Line chart with legend for each series.

 

[Rinki]

i like this chihiro, how did u make this.

 

[Rinki]

i would to try last of the last 2 guesses of hui.

 

[Chihiro]

See attached. Basically used Pivot to reorganize your table.

 

[Hui]

or Finally

 

[Rinki]

excellent hui dats wat i wanted..how did u do it. can i have the test file plz

 

[Hui]

This chart is not at all native to Excel and is hacked together to see if that is what you wanted

Note: It looks nothing like your original drawing !!!

 

[Rinki]

i m unable to reproduce it using 2d line chart

 

[Hui]

The line chart has 6 series 1 for each person
Click on the series
Follow that data and see where it comes from
You will see that each person has and additional 2000000 added to the values
The chart vertical axis has a Custom number format of "$k 2,000";;;

The names are in cells behind the chart but could be in TextBoxes within the chart and then linked to the names on the worksheet