 |
| Can you help? |
So my computer skills are not all that great. I know what is wrong with this chart and that is the label for the columns for the grain size. I cant seem to be able to label them the right way other than just the standard numbers it gives me. This is the only graph giving me problems. I would like to be able to label each column along the x axis. Any help would be appreciated. If im on the wrong path with this one would you let me know too.
Thank you!
Without your Excel spreadsheet it is hard to tell but I don't think you actually have an x-axis. I believe the symbols on the bottom with the colored boxes is just a legend that usually pops up to the right of my graphs.
ReplyDeleteIn my graph the columns are labeled "S1" and so forth along the x-axis, and the legend indicates what grain size corresponds to what color in the column of the graph. If that is what you want, do the following:
When you highlight the data in your table in order to then create a graph based on that data, you need to include the column all the way on the left (S1-S4, a.k.a A4 to A7). Once you have created the stacked column you may have to select "Switch Row/Column" under the "Design" tab.
Angela! You have now rated the status of Excel Queen.
Delete