Line Graph - Missing last column of data

meso100

New Member
Joined
Mar 20, 2013
Messages
7
Probably/hopefully an easy solution.

I am trying to provide a graph to a client for MI purposes but the line graph isn't including the last column of data.

Along the bottom I have Oct-12, Nov-12 etc to Jun-13 but it won't include Jul-13 from the table. Even if I stretch the graph. The table is full of data and has 3 line graphs in total but I want this spanning across a calendar year or more.

Is there a limitation of there only being able to use 9 columns of data in this type of graph?

If not, what could be the issue?

ps: I am not able to do anything fancy here with regards to a solution. If its doing something different in my formatting or using the wizard then great but much else and I have limited expertese.

Thanks
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
If it won't stretch, how about right-click on the chart and select Change Data and select the new rows/columns. This way you can select which data series it goes into.
 
Upvote 0

Forum statistics

Threads
1,214,833
Messages
6,121,858
Members
449,052
Latest member
Fuddy_Duddy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top