I have Excel 2007.
I am trying to model the populations of lynx and hares in Canada over 90 years. I have the data for the ninety years, and have created a model. The model, however, requires me to use 9000 pieces of information as I have to use 0.01year increments. How can I chart this data all on one chart (either line or scatter type)? Thus far everything I try puts 9000 on the x-axis, but I want 90 on the x-axis and the model information to be scaled down to this.
Thank you in advance
Welcome to the forum. Those were two pretty good mathemeticians.
If you use a scatter plot (versus a line graph) and the x axis data goes from 0 to 90 in 0.01 (or any other) increments, then the domain of points will be from 0 to 90.
Please take a few minutes to read the Forum Rules about thread titles before starting your next thread. Your thread title is totally unrelated to your question.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
How do I choose the x-axis points, however?
I apologise for the title.
Post a zipped workbook?
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
The data on the left is the data I have.
On the right is the model data.
The years are between 1844 and 1934, but I have 2 columns for year number, Column b is just increasing by year, and column f is increasing by 0.01.
Many thanks
I changed the blank data values to #N/A so they wouldn't plot, then used the chart wizard to add the first two series (data) plotted against col B, and then added the next two series (model) to plot against col F.
I also moved the coefficients in f(x,y) and g(x, y) to separate cells.
Looks like the model needs some tweaking
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
thank you very, very much!
You're welcome. Please mark the thread as solved?
-----------------------------------------------
To mark a thread as solved:
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
If more than two days have elapsed since your first post, ask a moderator to mark it.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks