Assume you have a data of 12 lines that time sensitive due to the
dates they would be filled. Each line would be a number for that
month.

I get the whole, adding NA() to remove the zero so that it does not
plot. However, I wanted to take it a step further...

Currently, the graph will plot up to the month you are in. Let's
assume it is June. As for the X-axis it shows from January to
December, but the graph does not plot anything after June due to the
NA() function to remove any zero values.

If you have 12 lines to signify each month, is it possible so that the
categories seen on the X axis as well as what is plotted, to only show
from January to June instead of January to Decemeber but stops
plotting at June?

Use a formula for your X-axis series so that you only populate the cell with
a number if you have Y-axis values, and otherwise put NA() in there.
=IF(ISNA(y_value),NA(),x_value)
--
David Biddulph

"Noob Jedi" wrote in message
...
Assume you have a data of 12 lines that time sensitive due to the
dates they would be filled. Each line would be a number for that
month.

I get the whole, adding NA() to remove the zero so that it does not
plot. However, I wanted to take it a step further...

Currently, the graph will plot up to the month you are in. Let's
assume it is June. As for the X-axis it shows from January to
December, but the graph does not plot anything after June due to the
NA() function to remove any zero values.

If you have 12 lines to signify each month, is it possible so that the
categories seen on the X axis as well as what is plotted, to only show
from January to June instead of January to Decemeber but stops
plotting at June?

On Dec 20, 12:18 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Use a formula for your X-axis series so that you only populate the cell with
a number if you have Y-axis values, and otherwise put NA() in there.
=IF(ISNA(y_value),NA(),x_value)
--
David Biddulph

"Noob Jedi" wrote in message

...



Assume you have a data of 12 lines that time sensitive due to the
dates they would be filled. Each line would be a number for that
month.

I get the whole, adding NA() to remove the zero so that it does not
plot. However, I wanted to take it a step further...

Currently, the graph will plot up to the month you are in. Let's
assume it is June. As for the X-axis it shows from January to
December, but the graph does not plot anything after June due to the
NA() function to remove any zero values.

If you have 12 lines to signify each month, is it possible so that the
categories seen on the X axis as well as what is plotted, to only show
from January to June instead of January to Decemeber but stops
plotting at June?- Hide quoted text -

- Show quoted text -

Maybe I'm missing something here. I tried using your method in a new
worksheet. Assuming my X values are going to be from A1:A12 and my Y
values are going from B1:12. Obvoiusly, 12 for the number of months in
a year.

Your formula of:
=IF(ISNA(y_value),NA(),x_value

Makes the X value turn "#N/A" if the Y value is "#N/A." Otherwise, it
would say the X values.

In my case of having only data up to June, my colum of A1:A12 shows
A1:A6 with the respective name of the month and A7:A12 showing "#N/A."

When I create the chart and link it to the 12 rows, it still shows the
6 "#N/A" following the first 6 months named.

I'm wanting the chart to only show categories of January - June. No
indiciation of the "#N/A" categories included in the chart:

Like this:
5
4
3
2
1
Jan Feb March April May June

NOT:
5
4
3
2
1
Jan Feb March April May June #N/A #N/A #N/A #N/A
#N/A #N/A

What sort of chart are you plotting? I assumed you were using an XY chart
as you were talking about X and Y values?
--
David Biddulph

"Noob Jedi" wrote in message
...
On Dec 20, 12:18 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Use a formula for your X-axis series so that you only populate the cell
with
a number if you have Y-axis values, and otherwise put NA() in there.
=IF(ISNA(y_value),NA(),x_value)
--
David Biddulph

"Noob Jedi" wrote in message

...



Assume you have a data of 12 lines that time sensitive due to the
dates they would be filled. Each line would be a number for that
month.

I get the whole, adding NA() to remove the zero so that it does not
plot. However, I wanted to take it a step further...

Currently, the graph will plot up to the month you are in. Let's
assume it is June. As for the X-axis it shows from January to
December, but the graph does not plot anything after June due to the
NA() function to remove any zero values.

If you have 12 lines to signify each month, is it possible so that the
categories seen on the X axis as well as what is plotted, to only show
from January to June instead of January to Decemeber but stops
plotting at June?- Hide quoted text -

- Show quoted text -

Maybe I'm missing something here. I tried using your method in a new
worksheet. Assuming my X values are going to be from A1:A12 and my Y
values are going from B1:12. Obvoiusly, 12 for the number of months in
a year.

Your formula of:
=IF(ISNA(y_value),NA(),x_value

Makes the X value turn "#N/A" if the Y value is "#N/A." Otherwise, it
would say the X values.

In my case of having only data up to June, my colum of A1:A12 shows
A1:A6 with the respective name of the month and A7:A12 showing "#N/A."

When I create the chart and link it to the 12 rows, it still shows the
6 "#N/A" following the first 6 months named.

I'm wanting the chart to only show categories of January - June. No
indiciation of the "#N/A" categories included in the chart:

Like this:
5
4
3
2
1
Jan Feb March April May June

NOT:
5
4
3
2
1
Jan Feb March April May June #N/A #N/A #N/A #N/A
#N/A #N/A

On Dec 20, 2:48 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
What sort of chart are you plotting? I assumed you were using an XY chart
as you were talking about X and Y values?
--
David Biddulph

"Noob Jedi" wrote in message

...



On Dec 20, 12:18 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Use a formula for your X-axis series so that you only populate the cell
with
a number if you have Y-axis values, and otherwise put NA() in there.
=IF(ISNA(y_value),NA(),x_value)
--
David Biddulph

"Noob Jedi" wrote in message

...

Assume you have a data of 12 lines that time sensitive due to the
dates they would be filled. Each line would be a number for that
month.

I get the whole, adding NA() to remove the zero so that it does not
plot. However, I wanted to take it a step further...

Currently, the graph will plot up to the month you are in. Let's
assume it is June. As for the X-axis it shows from January to
December, but the graph does not plot anything after June due to the
NA() function to remove any zero values.

If you have 12 lines to signify each month, is it possible so that the
categories seen on the X axis as well as what is plotted, to only show
from January to June instead of January to Decemeber but stops
plotting at June?- Hide quoted text -

- Show quoted text -

Maybe I'm missing something here. I tried using your method in a new
worksheet. Assuming my X values are going to be from A1:A12 and my Y
values are going from B1:12. Obvoiusly, 12 for the number of months in
a year.

Your formula of:
=IF(ISNA(y_value),NA(),x_value

Makes the X value turn "#N/A" if the Y value is "#N/A." Otherwise, it
would say the X values.

In my case of having only data up to June, my colum of A1:A12 shows
A1:A6 with the respective name of the month and A7:A12 showing "#N/A."

When I create the chart and link it to the 12 rows, it still shows the
6 "#N/A" following the first 6 months named.

I'm wanting the chart to only show categories of January - June. No
indiciation of the "#N/A" categories included in the chart:

Like this:
5
4
3
2
1
Jan Feb March April May June

NOT:
5
4
3
2
1
Jan Feb March April May June #N/A #N/A #N/A #N/A
#N/A #N/A- Hide quoted text -

- Show quoted text -

That is correct. After Googling it a little more, I realized that what
I'm trying to do is called a Dynamic Chart. However, much of the
tutorials online are a bit confusing. Perhaps you could dumb it down
for me?

My method worked quite happily for me the way I described it. I got X
values where I'd got numbers, and the NA() X values were ignored. It sounds
to me like you've got text, rather than dates formatted to show as month
names.
--
David Biddulph

"Noob Jedi" wrote in message
...

That is correct. After Googling it a little more, I realized that what
I'm trying to do is called a Dynamic Chart. However, much of the
tutorials online are a bit confusing. Perhaps you could dumb it down
for me?

On Dec 20, 2:48 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
What sort of chart are you plotting? I assumed you were using an XY
chart
as you were talking about X and Y values?

"Noob Jedi" wrote in message
...

Maybe I'm missing something here. I tried using your method in a new
worksheet. Assuming my X values are going to be from A1:A12 and my Y
values are going from B1:12. Obvoiusly, 12 for the number of months in
a year.

Your formula of:
=IF(ISNA(y_value),NA(),x_value

Makes the X value turn "#N/A" if the Y value is "#N/A." Otherwise, it
would say the X values.

In my case of having only data up to June, my colum of A1:A12 shows
A1:A6 with the respective name of the month and A7:A12 showing "#N/A."

When I create the chart and link it to the 12 rows, it still shows the
6 "#N/A" following the first 6 months named.

I'm wanting the chart to only show categories of January - June. No
indiciation of the "#N/A" categories included in the chart:

Like this:
5
4
3
2
1
Jan Feb March April May June

NOT:
5
4
3
2
1
Jan Feb March April May June #N/A #N/A #N/A #N/A
#N/A #N/A

On Dec 20, 12:18 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Use a formula for your X-axis series so that you only populate the
cell
with
a number if you have Y-axis values, and otherwise put NA() in there.
=IF(ISNA(y_value),NA(),x_value)
--
David Biddulph

"Noob Jedi" wrote in message

...

Assume you have a data of 12 lines that time sensitive due to the
dates they would be filled. Each line would be a number for that
month.

I get the whole, adding NA() to remove the zero so that it does not
plot. However, I wanted to take it a step further...

Currently, the graph will plot up to the month you are in. Let's
assume it is June. As for the X-axis it shows from January to
December, but the graph does not plot anything after June due to the
NA() function to remove any zero values.

If you have 12 lines to signify each month, is it possible so that
the
categories seen on the X axis as well as what is plotted, to only
show
from January to June instead of January to Decemeber but stops
plotting at June?- Hide quoted text -

Hi,

You can use named ranges to only plot the data points up to the first
empty point.
See this page on various ways of using named ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html

Alternatively you could hide those rows, using autofilter.
Check that the chart is set to Only plot visible cells.
With the chart selected use Tools Options Chart, to check this.

Cheers
Andy

Noob Jedi wrote:
Assume you have a data of 12 lines that time sensitive due to the
dates they would be filled. Each line would be a number for that
month.

I get the whole, adding NA() to remove the zero so that it does not
plot. However, I wanted to take it a step further...

Currently, the graph will plot up to the month you are in. Let's
assume it is June. As for the X-axis it shows from January to
December, but the graph does not plot anything after June due to the
NA() function to remove any zero values.

If you have 12 lines to signify each month, is it possible so that the
categories seen on the X axis as well as what is plotted, to only show
from January to June instead of January to Decemeber but stops
plotting at June?