Hi,
I have three sets of data showing how Company X is performing against industry avg and median. I would like to translate that into a graph. Which graph is the best. Please follow me through the steps thanks
Hi,
I have three sets of data showing how Company X is performing against industry avg and median. I would like to translate that into a graph. Which graph is the best. Please follow me through the steps thanks
I selected your data and copied it and pasted TRANSPOSED so that the years are down the column and the values are in the rows. I also changed your mix of % and numbers to all numbers because the chart was grossly distorted and didn't show much. I chose a Scatter chart and on the Y axis I changed the Minimum to fixed at 400 and the Maximum fixed at 600.
I think that this will result in something understandable.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks