Chart formatting

[bh24524]

Hello, I rarely work with charts so I apologize if this is ridiculously simple, but I am doing one now as pictured below:

My question is simple, is there a way to make it so that the years display right under the bars where I drew the X's? I really like that it has the dollar amounts above the bars, but I was wondering how I might get the years under the bars if that is possible instead of where they are?

 

[awoohaw]

Change your year values to date values and format as "YYYY" Then use that as your x axis instead of a series name:

(notice that cell A3 value is actually 1/1/2016, but formatted as YYYY)

 

[bh24524]

Hi awoohaw, I did change the date portion, but I can't find where I need to change the other portion. Sorry if it's simple, I just never work with charts to know my way around or what to look for. Can you point me in the direction?

 

[awoohaw]

I really don't know how to type in a sentence or two how to select data for a chart.
But in your chart plotting area right click to open up the ALT-MENU drop down and select "SELECT DATA" or "CHANGE DATA".
then do something like this:

Here is the workbook, but it will not have the chart object as that is not copied with the xl2bb add in:
And the dates in column A may need to be changed to fit your regional settings:

Mr Excel Questions 74.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2	Year	Dollar Volume
3	2016	$24,334.75
4	2017	$76,467.75
5	2018	$8,060.08
6	2019	$8,340.20
7	2020	$5,406.81
8	2021	$28,286.75
9	2022	$6,206.30
10	2023	$13,293.14
11	2024	$733.04
12
13
14
15
16
17
18
19
Sheet3

 

[jolivanes]

Right click where you have the x's below the bars.
click on "Select data"
Under "Horizontal (Category) Axis Labels", click on Edit
With your mouse select the range from 2016 to 2024 (Axis Label Range)
Click on OK

 

[RoryA]

It looks like you've plotted each year as a separate series, so you could probably just go into the Select Data dialog and press the Switch Row/Column button:

If you still want different colours for each column, then in the Format Series dialog click the Vary colors by point option:

 

[bh24524]

Thank you all for the help, I was able with the instructions to do what I wanted so that it looks like this:

Thank you for all the guidance on this!