#1
|
|||
|
|||
Generating a chart with dynamic series
Hi,
I am using Excel 2013. Currently, I have to make a chart, that is not a problem in itself. It's the data series that is difficult: The chart is supposed to show all the data for the current month - but only up to today. Excel is not the tool I'm generally working with at the moment. I have been working with Excel a lot in my previous jobs, but now I'm into QlikView and not so fast anymore in Excel. I don't know exactly how to tweak a chart once I have created it. There seem to be only a limited number of options available, and dynamically limiting the x-axis is not among them if I haven't overlooked it. What I can do of course is just use a series of the dates in the current month in one row and then use and the letters of the respective column below that and then use an HLOOKUP in some cell to display what column has today's date. => I guess I have to somehow include a reference to that cell in the definition of the data_series to use for that chart, but how to do that? (I can of course construct the statement denoting the necessary range (like >> $C$47:$H$47 <<) in another cell, but then just clicking on that cell for the dimension_range of that chart does not seem to do the trick) |
#2
|
||||
|
||||
Perhaps look at http://peltiertech.com/Excel/Charts/...umnChart1.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Tushar Mehta also has some nice charts.
See attached for some possibilities @ pecoflyer Reg "Je suis Charlie" Moi aussie |
#4
|
|||
|
|||
Okay, thank you all!
I have made it. I simply introduced a number denoting the month of the date into the source list and using this I constructed a COUNTIFS() statement. It works now. Best regards, Officer_Bierschnitt |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Generating a Letter | Shanna86 | Word | 9 | 09-29-2015 09:11 PM |
Dynamic Chart with Non Continuous data | swati_04 | Excel | 0 | 03-02-2015 12:06 AM |
chart data series information in slideshow | jonen | PowerPoint | 0 | 09-24-2014 01:10 AM |
Generating Buy/Sell signals accordingly... | babapusy | Excel | 0 | 04-14-2012 10:11 AM |
Custom animating a line chart by series and category. | Gahzi | PowerPoint | 0 | 05-19-2009 11:53 AM |