Swap Axes in Excel (97)

Topic

New Reply

Sounds simple, but confusing without some data. Can you attach a small worksheet with sample data and describe again how the chart should look? TIA –Sam

Reply | Quote

Replies

I’m trying to create a scorecard for a business. Is there a way to make the x-axis the value axis instead of the y-axis? Even better, can I create a graph with one horizontal axis that has left to right values of one to ten, perhaps a series, and a second series showing values between one and ten representing scores over time. Sample in Word 97 attached.

Reply | Quote

What do the sigma’s and the set symbols mean? What about a simple column chart like one of the attached?

Reply | Quote

They are actually Monotype sorts. They are markers and labels for the datapoints.

Reply | Quote

I don

Reply | Quote

Have you tried changing the chart type from Bar to column? I’m currently using 2000, but I believe ’97 works the same.

Reply | Quote

I think you want a stacked bar chart using a single data set…but I don’t know how to do that, frankly.

Reply | Quote