?
Solved

vertical line excel chart showing date today

Posted on 2009-02-11
2
Medium Priority
?
388 Views
Last Modified: 2012-05-06
Hi @ all,

I have an Excel chart that shows different values, X = a value like January until December,
Y = Vailue like dollars, now I want a split for the actual month like a vertical line.

How can I solve that?
0
Comment
Question by:dr-goebel
2 Comments
 
LVL 50

Expert Comment

by:Dave Brett
ID: 23610399
Can you pls upload a sample chart
thx
Dave
0
 

Accepted Solution

by:
dr-goebel earned 0 total points
ID: 23610435
Here you go...

There must be a Date() function for "Today" and this date must be a vertical line to "sign" the actual date...
sample.xls
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question