Thread: Charting days with date

Hi,

I am fairly new to Excel and am trying to chart some data using days of the week, but only Tuesdays and Fridays. I have 1 column with the dates and the second column with the data. How do I go about making my x axis show just the day and date, for Tuesdays and Fridays only? Thanks.

Do you mean that you have data for Tuesdays and Friday only, or that you have all the days of the week, but just want to graph Tuesdays and Fridays? Sorry - a little confused there, but it shouldn't matter.
Have you tried using a line graph? If you select the dates in the column as your x-axis values (Source Data -> Series -> Category (x) axis labels) it should come up as the x-axis labels on the graph.

Yes, I have data for all days of the month, but only want to graph Tuesdays and Fridays. I have tried what you referred to and it will plot just that data, but the labels reflect a different series. Sorry for the confusion, but a basically only want to plot Tuesdays and Fridays of each week, and want the labels to reflect only those days by day of the week and date. Hope that help clarify. Thanks.

You may have to reorganize the data, if the dataset if large enough you may want to use a macro, but you can hold Ctrl and click every row that a Tuesday or Friday falls on, and then copy it either below or into a new workbook.
Do you think you could post a sample of the workbook? A visual may be easier to understand.

Here is the data along with a sample chart. Dates are giving me the problem. I would like it to see only the days it plots, i.e., 11/4, along the bottom. It is currently giving me every 2 days for dates. Is there a way it would show Tue 11, for day of the week and date? Hope that helps. Thanks.

I see what the problem is now...unfortunately I can't remember how to fix it!
Only thing I can see, and I tried it in your worksheet, is to make the date and day into a seperate column, and then graph it.
Sorry I couldn't help more!