I have created a chart that shows the views and sales I have on my site for each day of the year. My question is, can I easily have it only show me data for, let's say, Fridays so I can compare those to see if there is a trend?
I have created a chart that shows the views and sales I have on my site for each day of the year. My question is, can I easily have it only show me data for, let's say, Fridays so I can compare those to see if there is a trend?
1 way would be to create a 2nd table that will only pull in those days you want - then base the chat on that. Otehr than that, without seeing your data, hard to say.
maybe consider upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is a small sampling of my data. It's a very small chart, but it goes on throughout the entire year.
You could add a coupple of extra fields to your data and use a pivot table/chart.
You can then filter by month and or day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks