I have an Excel file with 3 columns
week number, total visitors, visitor gender.
The visitor gender can be male, female.
I create a bar chart by selecting all the rows and all 3 columns, then click Insert, Columns, 2-D columns chart. It gives empty chart because column 2 contains integers while column 3 contains characters.
I change visitor gender to 1 (for male) and 2 for female and can create a chart but that's not what I want. Is it possible to create a chart when the two columns are of different data type and how? It worked fine with Excel 2003.
In addition, once a chart is created, how can I widen the width of each line in the chart?
Thank you.
Bookmarks