Multiple Data Points for a Single Day

**SheilaV** · 07-04-2008, 05:00 PM

I have some data points, the number of them vary day to day. I want to plot the points either scatter connected with lines or line graph so that all the points are shown and the X-axis shows the date at the beginning point of that day only. Does anyone know how I can do this?

**shg** · 07-04-2008, 05:02 PM

Probably using a dynamic named range.

Can you post a workbook, so the answer can be specific?

**SheilaV** · 07-08-2008, 02:56 PM

This is just the beginning of the data. Each point listed under a date should be plotted connected by lines between that day and the next day. Where the dates are plotted on the x and the data on the y. I have tried setting up the numbers differently but if I make the date the x value for plotting and the data the y it ends up plotting it all in vertical lines.

**Andy Pope** · 07-08-2008, 03:17 PM

I'm not sure exactly what you want the chart to look like.

This plots each row as a series, Line. with dates as categories.
The data range has been made into a list (table in xl2007) and the chart is based on the list so new rows and columns will automatically appear.

**SheilaV** · 07-09-2008, 10:13 AM

I have rearranged the data to make it more clear what I am trying to do. If you look at the wooksheet. I would like to plot the numbers from column B in a scatter plot connected with lines, or a line graph so that all the points are plotted like in chart 1 but I would like the x-axis to reflect the dates that the data is from, where the dates are shown in column A.

**TheNorm** · 07-09-2008, 12:15 PM

Like this?

**Andy Pope** · 07-10-2008, 05:16 AM

Still unclear exactly what you want.

Basically a chart can only plot the information you give it.

**SheilaV** · 07-10-2008, 10:37 AM

Thanks Andy, that was exactly what I was looking for (line chart with categories)!

**mazdaq1** · 06-05-2013, 12:46 PM

Sorry to drag an old thread up. I am having exactly the same problem. Andy, the chart in your last post entitled 'Line chart as categories' displays the data in exactly the way I want to display mine. However, when I try to draw a line chart, it displays multiple data values for the same day at the same point on the x-axis so there is just a vertical line connecting all values. I want it to display the data so that each data value is plotted at a different point on the x-axis, next to the last data value. How did you get it to plot the data in the way shown in your chart? I have been struggling with this problem for hours now! Thanks in advance.

**arlu1201** · 06-05-2013, 12:52 PM

mazdaq1,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

**Dag83** · 08-20-2019, 02:49 AM

Hi,
I got the same problem, but i can't download the files unless i post something.
So thanks for the help

**AliGW** · 08-20-2019, 02:51 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread