I am trying to design a chart on Excel with 2 CAD data, 2 for each row information. My problem is that the size of the columns is very small. I clicked row for formatting, but size does not change too much. As it is I can enlarge the size?
I am trying to design a chart on Excel with 2 CAD data, 2 for each row information. My problem is that the size of the columns is very small. I clicked row for formatting, but size does not change too much. As it is I can enlarge the size?
You mean the width of histograms?
The dialog format of a graphic was still somewhat sketchy on Excel but you can already play on this setting in the last tab of this box ("Options" tab, memory).
You can include expanding the bars until they touch (setting back to 0) and define the overlap if you have two or more series.
I did exactly as you say, but the bars are not too wide.
If you double-click a bar of the histogram, it opens the "Format Data Series". The tab "Options" offers a setting of the "Gap width". When it is 0, the histogram bars are touching.
More broadly, it is not possible! Or superimposing bars, what sets the option to later ...
But the same thing works perfectly ok at my home with computer running Excel 2007, but, however, why doesn't it work in my office where I am running Excel 97. So do I need to upgrade to the newer version at my office?
Bookmarks