Creating a Line Graph

[reberryjr]

I work with Excel a lot, but have never really had the need to use graphs. For the project I'm working on, I'd like to use some. I'd like to run the values of a column along the bottom of the graph (the X axis?), and have the values of a few other columns serve as the actual lines (the Y axis?). I managed to build everything, but can't seem to get the values of the X axis to appear at the bottom of the graph. Instead, they appear smack dab in the middle of the graph.

Eventually, I'd like to have the chart created in vba, but I'm trying to build it manually first, so that I know exactly what I'm looking for.

 

[mole999]

https://peltiertech.com/

 

[reberryjr]

It looks like that will help me create the code, once I get to that point. Allow me to ask another question. Is there a way to limit the chart to only pulling in certain records? For instance, the minimum date and the 3 max dates from a column? I'm concerned that the size of the chart may get quite large, making it less useful.

 

[mole999]

one way is to hide columns or rows, don't know if thats what you need to do

 

[thisoldman]

... but can't seem to get the values of the X axis to appear at the bottom of the graph. Instead, they appear smack dab in the middle of the graph....

You most likely have negative values in the data. An example:

[TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"]Alpha[/TD]
[TD="class: xl64, width: 64"]Beta[/TD]
[TD="class: xl64, width: 64"]Gamma[/TD]
[/TR]
[TR]
[TD="class: xl64"]Q1[/TD]
[TD="class: xl64, align: right"]2[/TD]
[TD="class: xl64, align: right"]-1[/TD]
[TD="class: xl64, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl64"]Q2[/TD]
[TD="class: xl64, align: right"]1[/TD]
[TD="class: xl64, align: right"]0[/TD]
[TD="class: xl64, align: right"]-2[/TD]
[/TR]
[TR]
[TD="class: xl64"]Q3[/TD]
[TD="class: xl64, align: right"]0[/TD]
[TD="class: xl64, align: right"]1[/TD]
[TD="class: xl64, align: right"]-2[/TD]
[/TR]
[TR]
[TD="class: xl64"]Q4[/TD]
[TD="class: xl64, align: right"]-1[/TD]
[TD="class: xl64, align: right"]2[/TD]
[TD="class: xl64, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

Plots like this, by default:

If you have a fixed limit vertical axis,
Select the vertical or y-axis.
In the format pane, select the small icon that looks like a column chart.
Under Axis Options, in the section headed "Horizontal axis crosses", select the "Axis value" radio button.
Type in the y-value where you want the x-axis to cross. In my example, I entered -3.

You can move just the labels.
Select the horizontal or x-axis.
In the format pane, select the small icon that looks like a column chart.
In the section titled "Labels", change "Label Position" to "Low".