ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CHARTS (https://www.excelbanter.com/excel-discussion-misc-queries/259651-charts.html)

ColleenK

CHARTS
 
Hi There,

When creating charts, my bars of data are fine line and I am trying to
figure out how to make the bars thicker, there is over an inch of space
between each reporting period, can anyone tell me why this is happening.

Thanks so much
Colleen
--
CK

trip_to_tokyo[_3_]

CHARTS
 
EXCEL 2007

Try the following:-

(I have a Clustered Column chart on the screen in front of me)

- click on one of the columns to highlight that Data Series

- right click / Format Data Series . . .

- Format Data Series window should launch

- Series Options should be highlighted in orange on the left hand side

- adjust Series Overlap and / or Gap Width setting on right hand side

If my comments have helped please hit Yes.

Thanks.



"ColleenK" wrote:

Hi There,

When creating charts, my bars of data are fine line and I am trying to
figure out how to make the bars thicker, there is over an inch of space
between each reporting period, can anyone tell me why this is happening.

Thanks so much
Colleen
--
CK


ColleenK

CHARTS
 
Hi There,

I tried that and it does not work.

Colleen
--
CK


"trip_to_tokyo" wrote:

EXCEL 2007

Try the following:-

(I have a Clustered Column chart on the screen in front of me)

- click on one of the columns to highlight that Data Series

- right click / Format Data Series . . .

- Format Data Series window should launch

- Series Options should be highlighted in orange on the left hand side

- adjust Series Overlap and / or Gap Width setting on right hand side

If my comments have helped please hit Yes.

Thanks.



"ColleenK" wrote:

Hi There,

When creating charts, my bars of data are fine line and I am trying to
figure out how to make the bars thicker, there is over an inch of space
between each reporting period, can anyone tell me why this is happening.

Thanks so much
Colleen
--
CK



All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com