Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-07-2015, 06:04 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 78
Officer_Bierschnitt is on a distinguished road
Default 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)
Reply With Quote
  #2  
Old 10-07-2015, 11:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,987
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Perhaps look at http://peltiertech.com/Excel/Charts/...umnChart1.html
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Reply With Quote
  #3  
Old 10-10-2015, 01:54 PM
jolivanes jolivanes is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 77
jolivanes will become famous soon enough
Default

Tushar Mehta also has some nice charts.
See attached for some possibilities

@ pecoflyer Reg "Je suis Charlie"
Moi aussie
Attached Files
File Type: xlsm Tushar Mehta Dynamic Names And Charts.xlsm (34.9 KB, 1 views)
Reply With Quote
  #4  
Old 10-15-2015, 12:30 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 78
Officer_Bierschnitt is on a distinguished road
Default

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
Reply With Quote
Reply

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


All times are GMT -7. The time now is 06:38 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft