ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Simple Charting Problem, Please (https://www.excelbanter.com/excel-discussion-misc-queries/453005-simple-charting-problem-please.html)

Bob[_19_]

Simple Charting Problem, Please
 
Hello,

Using Excel from, I think, 2007, and Windows 10.

Haven't used in a while, and I am probably forgetting things, but
this is really confusing me.

If anyone can help me out, would be most appreciative.

Plotting Blood p:

Column A has dates.
Column B has pressure.

Really a simple setup.
Scatter graph is desired, with straight lines between the actual points.

Lets say I have 10 dates.

If I select these 10 to plot, no problem.
Does it all nicely.

But if I select, e.g., 15 rows to Plot, with
the last five being Blank, it won't do it.

In the "Select Data", the dates only show for the first case, where
there is actual data in the cells.

What am I missing (as usual), or doing wrong ?

I would really like to have the resultant graph set up
to encompass a wide range of dates, even though we may have no data
filled in (yet) for many of them.

Happy Holidays, and thanks,
Bob

Claus Busch

Simple Charting Problem, Please
 
Hi Bob,

Am Sun, 25 Dec 2016 10:56:29 -0500 schrieb Bob:

Plotting Blood p:

Column A has dates.
Column B has pressure.

Really a simple setup.
Scatter graph is desired, with straight lines between the actual points.

Lets say I have 10 dates.

If I select these 10 to plot, no problem.
Does it all nicely.

But if I select, e.g., 15 rows to Plot, with
the last five being Blank, it won't do it.


name the ranges of x and y values and use these names for the chart.Then
your chart is always present with the current data.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYI-fCz3P6SW4iUuyQ


Regards
Claus B.
--
Windows10
Office 2016

GS[_6_]

Simple Charting Problem, Please
 
Hi Bob,

Am Sun, 25 Dec 2016 10:56:29 -0500 schrieb Bob:

Plotting Blood p:

Column A has dates.
Column B has pressure.

Really a simple setup.
Scatter graph is desired, with straight lines between the actual
points.

Lets say I have 10 dates.

If I select these 10 to plot, no problem.
Does it all nicely.

But if I select, e.g., 15 rows to Plot, with
the last five being Blank, it won't do it.


name the ranges of x and y values and use these names for the
chart.Then your chart is always present with the current data.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYI-fCz3P6SW4iUuyQ


Regards
Claus B.


Making this data range 'dynamic' would be best so it self-sizes and its
chart auto-updates accordingly!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

William B. (Billby)

Simple Charting Problem, Please
 
On 26/12/2016 4:42 AM, GS wrote:
Hi Bob,

Am Sun, 25 Dec 2016 10:56:29 -0500 schrieb Bob:

Plotting Blood p:

Column A has dates.
Column B has pressure.

Really a simple setup.
Scatter graph is desired, with straight lines between the actual points.

Lets say I have 10 dates.

If I select these 10 to plot, no problem.
Does it all nicely.

But if I select, e.g., 15 rows to Plot, with
the last five being Blank, it won't do it.


name the ranges of x and y values and use these names for the chart.Then your chart is always
present with the current data.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYI-fCz3P6SW4iUuyQ


Regards
Claus B.


Making this data range 'dynamic' would be best so it self-sizes and its chart auto-updates accordingly!


Excellent advice from Claus and GS, however creating a 'Dynamic Named Range' for a casual Excel user
is not a trivial task... Amongst other things it requires knowledge of the OFFSET function.

This link provides a detailed explanation:

http://www.excel-easy.com/examples/d...med-range.html


GS[_6_]

Simple Charting Problem, Please
 
On 26/12/2016 4:42 AM, GS wrote:
Hi Bob,

Am Sun, 25 Dec 2016 10:56:29 -0500 schrieb Bob:

Plotting Blood p:

Column A has dates.
Column B has pressure.

Really a simple setup.
Scatter graph is desired, with straight lines between the actual
points.

Lets say I have 10 dates.

If I select these 10 to plot, no problem.
Does it all nicely.

But if I select, e.g., 15 rows to Plot, with
the last five being Blank, it won't do it.

name the ranges of x and y values and use these names for the
chart.Then your chart is always
present with the current data.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYI-fCz3P6SW4iUuyQ


Regards
Claus B.


Making this data range 'dynamic' would be best so it self-sizes and
its chart auto-updates accordingly!


Excellent advice from Claus and GS, however creating a 'Dynamic Named
Range' for a casual Excel user is not a trivial task... Amongst other
things it requires knowledge of the OFFSET function.

This link provides a detailed explanation:

http://www.excel-easy.com/examples/d...med-range.html


I was replying to Claus' offering of an example (not viewed by myself).
It would be better for the OP if Claus' example included this since,
even after reading the article you refer to (good as it is) it still
may prove a daunting challenge to 'casual' users who use headers (as I
suspect ths OP does for checkbox cols)!

Not meaning to discourage others, though, I'd likely recommend further
reading here...

http://www.contextures.com/tiptech.html

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Claus Busch

Simple Charting Problem, Please
 
Hi Garry,

Am Sun, 25 Dec 2016 15:42:57 -0500 schrieb GS:

Making this data range 'dynamic' would be best so it self-sizes and its
chart auto-updates accordingly!


in my example the range names are dynamic. I thought this would be
obvious as I wrote :
Then your chart is always present with the current data.


Regards
Claus B.
--
Windows10
Office 2016

Thế45363

Cho thuê sân khấu - Thi công lắp dựng sân khấu -LH 0937 150 220


Đạt Phương - Đơn vị chuyên cung cấp, cho thuê âm thanh - ánh sáng - cung cấp, lắp đặt sân khấu phục vụ sự kiện chuyên nghiệp. ... Chuyên thiết kế, cung cấp v* lắp đặt hệ thống thiết bị âm thanh, ánh sáng, không gian, ...sân khấu. Liên hệ Mr Đạt 0911 000 222



[center]












GS[_6_]

Simple Charting Problem, Please
 
Hi Garry,

Am Sun, 25 Dec 2016 15:42:57 -0500 schrieb GS:

Making this data range 'dynamic' would be best so it self-sizes and
its chart auto-updates accordingly!


in my example the range names are dynamic. I thought this would be
obvious as I wrote :
Then your chart is always present with the current data.


Regards
Claus B.


I didn't view your sample, but no surprise that you did it that way!<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Thế45363

Cho thuê sân khấu - Thi công lắp dựng sân khấu -LH 0911 000 222


Đạt Phương - Đơn vị chuyên cung cấp, cho thuê âm thanh - ánh sáng - cung cấp, lắp đặt sân khấu phục vụ sự kiện chuyên nghiệp. ... Chuyên thiết kế, cung cấp v* lắp đặt hệ thống thiết bị âm thanh, ánh sáng, không gian, ...sân khấu. Liên hệ Mr Đạt 0907 150 220



[center]








William B. (Billby)

Simple Charting Problem, Please
 
Thanks Clause,

Over many years I've received more help from your contributions than anyone else's but in this case
clicking on your link from the mail message I received it in opened your page in my browser which
was interesting but didn't really help me learn how to make my own charts dynamic, hence my quest to
find our more.

Overall I'm disappointed that Excel doesn't provide a simple 'one click' means to make any chart
series dynamic, but then I probably expect too much.


On 26/12/2016 12:56 PM, Claus Busch wrote:
Hi Garry,

Am Sun, 25 Dec 2016 15:42:57 -0500 schrieb GS:

Making this data range 'dynamic' would be best so it self-sizes and its
chart auto-updates accordingly!


in my example the range names are dynamic. I thought this would be
obvious as I wrote :
Then your chart is always present with the current data.


Regards
Claus B.


Claus Busch

Simple Charting Problem, Please
 
Hi William,

Am Tue, 27 Dec 2016 08:15:40 +0800 schrieb William B. (Billby):

Over many years I've received more help from your contributions than anyone else's but in this case
clicking on your link from the mail message I received it in opened your page in my browser which
was interesting but didn't really help me learn how to make my own charts dynamic, hence my quest to
find our more.


first create dynamic range names. Then use them for the chart. You have
to write the book name with it's extentions in front of the name.
E.g. for the x values in my example
BloodPressure.xlsx!x_Values

Another way to make the chart dynamic:
Format your data as table and then create the chart.


Regards
Claus B.
--
Windows10
Office 2016

kqxsmn

Cái n*y HOT đây
_________________
https://t.co/IrSABSVSLH


All times are GMT +1. The time now is 06:55 AM.

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