All Questions
18
questions
0
votes
1
answer
66
views
Unable to format date axes on excel
I have various dates from 1995 to now in my excel database, I am trying to count no of entries for each date and plot the date(x-axis) vs count(y-axis) plot
So first I create a pivot on date column ...
1
vote
1
answer
323
views
Change the Chart Style for a Line Chart in Excel with Openpyxl
I have this following code to export a set of dataframes and then convert them to tables in excel and applying a color format, then it creates Line Graphs for every table, everything works but I'm ...
0
votes
1
answer
128
views
Line graph with markers plotting a zero starting value rather than actual value
I am doing a line graph with markers of four columns and the date on the x axis.
Column C is the values I want to plot.
The other columns (E to G) are constant lines to indicate the lower and upper ...
0
votes
1
answer
33
views
Build a line graph in excel sheet
I have a table with the following data(PFA the image), requirement is to build a line graph with Date in X-Axis and Count in Y-Axis, the Systems should be of each series. When I select the Date column ...
2
votes
1
answer
2k
views
Excel set color of line graph based on color of cells
So I have a set of data, see picture below.
I want the color of the line graph to be the same as the background color of the corresponding row. The top 10 should be green, and the bottom 10 red in ...
0
votes
1
answer
40
views
Is it possible to concatenate data from a row and a column together to display on the axis of a line graph?
In Excel, if I have data entered in a matrix format with rows representing years and the columns representing quarters, is there a method to concatenate the row/column names together when selecting ...
1
vote
1
answer
141
views
Plot a Line Graph
There is a scenario where I have to create a line graph in excel or anywhere which represents two approaches. The parameters involved are:
The number of systems on which both old and new approach is ...
1
vote
0
answers
510
views
Excel VBA Plotting
I need to plot a line graph of a set of data using VBA on button click.
It Plots the data correctly but there are additional items which appear in the legends of the graph.
Here is a snapshot of the ...
0
votes
1
answer
113
views
How to insert additional data (inserting time periods without data) into an Excel spreadsheet to create more accurate line graphs?
First of all, sorry for the badly worded question, I'm struggling to describe exactly what I'm looking for in a concise way.
I have a spreadsheet which essentially lists the amount of customer ...
-1
votes
1
answer
620
views
Excel Charts: Is it possible to add specific text to the bars on a chart?
I have the following chart:
Which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August ...
1
vote
1
answer
1k
views
Excel - Multiple subsets of data on one line graph
I'm trying make a line graph that has multiple lines on it, each representing a question number and its data. I cannot get it to display properly. My data is structured like this...
Question ...
0
votes
1
answer
2k
views
Creating a Year Over Year Line Graph Based on Pivot Table
I am trying to compare Year over Year revenue for October on a line graph and I have decided my best approach is to create a pivot table with my month column grouped by a month and year format. My ...
0
votes
1
answer
544
views
epplus line graph change smooth line VB
I am using epplus to create a line graph which by default is a smooth line. I want to switch the smooth line off so that it is a straight line from point to point. I am using VB but cannot find the ...
1
vote
1
answer
178
views
Excel Line Chart Only Unique Dates
I have a set of data as follows:
Date Amount
8/8/2013 $0.00
8/16/2013 $1.60
8/16/2013 $2.40
8/16/2013 $4.40
8/16/2013 $8.40
8/16/2013 $8.40
8/17/2013 $6.40
8/17/2013 $5.40
8/17/...
14
votes
5
answers
137k
views
Ignore cells on Excel line graph
I am trying to draw a line graph in Excel 2010. The y column data source has some gaps in it and I want these to be ignored for the graph. Seems to default these to zero. I know the "Hidden and Empty ...