Vertical Line Charts
Hey Everyone! I've been working on this problem for a few days now and I can't get it going. I need to create a vertical line chart. It's easier to show in photos. I have this.... I want it to be rendered like this (created by rotating previous photo)..... What would become the Y-axis (the categories) are text. I've tried just flipping the axes in the "Select Data" dialog box, but I think the problem is that Excel keeps wanting anything on the Y-axis to be numerical rather than textual; it then messes up the values of my data across the X-axis when I try just flipping the two. Anyone have any ideas? I am not a coder; I can't write VBA. I'd be willing to learn, but I'm in the middle of thesis writing so that would be difficult to add at the moment. Thanks in advance! -Mike
