Centering a bar graph data based on horizontal axis categories rather than by series.
I don't know if this is the kind of question normally posed to this community and it is largely aesthetic, but here goes.
I am making a graph for data that had technical replicates for each gene (A, B, and C). The genes (102 pqm1, 102 N2, and 96 N2) are on the horizontal axis and are the major category for the graph. Some replicates had a value of '0', which I do want to represent on the graph. The issue that one replicate (102 N2, C) failed and was removed from the data set, but even if I don't include that empty cell in the selection box for the series, Excel centers that category around the second series in that category. This makes it look almost as though there is another '0' value, when in fact that data is simply nonexistent
If anyone knows how to individually move bars in this type of graph, or how to make a bar graph that is tied to x-axis categories but not series, I'd appreciate any advice!
[link] [comments]
Want to read more?
Check out the full article on the original site