Questions tagged [charts]

Graphs, charts and other graphical methods for showing data and their relationships.

Filter by
Sorted by
Tagged with
0 votes
2 answers
3k views

Excel: Display two currencies on graph axis

I am trying to display two currencies on the y-axis. I do not want two y-axis. Essentially, I am presenting to two audiences; some from South Africa (hence Rand), and some from the Netherlands (hence ...
0 votes
1 answer
31 views

Excel: Chart Event times for teams [closed]

I have a dataset that looks like below: Team Start End Days 1 5/22/18 8/13/18 83 2 5/24/18 6/30/18 37 1 5/28/18 7/10/18 43 2 6/4/18 8/10/18 67 3 6/6/18 6/26/...
1 vote
0 answers
382 views

How can I set the outline color for a barplot in Python?

I am creating a simple barplot: ax = lasso_output_df2.plot(kind='bar', title ="Spain Coefficient Variables [alpha_10]", figsize=(15, 10), legend=False, fontsize=12) ax.set_xticklabels(...
0 votes
1 answer
3k views

Prevent two sets of labels from overlapping in a bar chart

I have a bar chart in a dashboard that needs to be dynamically updateable. I've inserted two graphs in order to have two sets of labels in different places. Unfortunately, when the value is 0 or No ...
0 votes
1 answer
47 views

Looking for a formula for automatic member placement

Chart 2 Chart 1 Chart 1b I have a group page, and to keep track of my members' presence/absence, I created this. In chart 1, I manually have to write who's active/inactive. They have to be ...
0 votes
1 answer
524 views

don't draw line in a line chart for N/A cells

Edit: I try to clarify my question, since the replies given so far don't answer it. If in A1:A5 I have (empty lines describe empty cells): 1 2 3 4 I get the following chart: that is what I need. ...
6 votes
2 answers
5k views

Linked images in PowerPoint not updating

I have a PowerPoint (2010) presentation with two slides. Both slides contain an image (two different images), and the presentation is set to loop infinitely until ESC is pressed. An Excel file ...
1 vote
1 answer
61 views

Creating a combo chart with bar and data icons

I'm not sure if this is even possible. I'd like to create a chart like so: My data source is a pivot table with 3 columns - Category, Revenue and Growth (a calculated field). I'm thinking of a combo ...
-1 votes
1 answer
157 views

Scatter plot for multiple rows

I'm trying to plot the following data in Excel using a scatter plot Income 1960 1961 1962 1963 1964 1965 Algeria 1280 1085 855 1128 1170 1215 Argentina 5251 5448 5316 ...
0 votes
1 answer
77 views

Combo Chart not selecting data correctly

I can't figure out why the combo chart is not treating the second LA as the start of the line graph series. It knows what to do with MS and TX, but is making LA another bar instead of a line. ...
0 votes
1 answer
2k views

How to make multiple legends the same on a graph

I have a graph of 30 categories. Each category consists of about 200 entries. I would like to make groups of 5 look exactly the same on a graph, so that, for example, categories 1-5 are all ...
0 votes
0 answers
120 views

Excel Chart with two Y axes [duplicate]

I have a question about creating an excel chart with two Y axes. Suppose I have the following data: Horizontal Axis Primary Vertical Axis Secondary Vertical Axis Series 1 1 ...
3 votes
0 answers
598 views

When I try to edit Y-axis limit on LibreOffice, the data in the chart disappears

Has anyone encountered such an issue? Am I missing something? When I choose axis limits manually from Right Click > Format Axis > Scale, the data in the chart disappears or gets hidden. I am ...
3 votes
1 answer
42 views

Excel - Dynamic Charts

I have a series that looks like SERIES('Data'!$C$140;'Data'!$E$138:$Q$138;'Data'!$E$140:$Q$140;2) and in order to make it dynamic I'd like to replace the endpoints with a cell that depends on the ...
0 votes
1 answer
3k views

Excel: time series with markers for events

I have daily data for two stocks for about 10 years, and sometimes there are some specific events (such as an announcements or a political events, not numerical data) I would like to show on my graph. ...
0 votes
1 answer
3k views

create excel charts in separate sheet using vba

In Excel 2016, I am trying to write a vba sub that takes a worksheet containing some data and creates a new sheet which will be filled with charts that use the data in the original sheet. I have ...
5 votes
1 answer
29k views

Precisely position a chart in Excel

When making a chart in the worksheet (not an independent chart sheet), is there a way to position the chart a little more precisely? Instead of just leaving it there "floating"? I have a bunch of ...
2 votes
2 answers
2k views

How do I apply conditional formatting to a table from a graph?

As you can see in this example below, I would like to be able to put in red the negative numbers that are in the table below the graph. I would like to apply a conditional formatting on this table (...
2 votes
2 answers
6k views

Placing labels on data points in a stacked bar chart in Excel

Is it possible to place the labels not on the Y axis, but on the data point itself in a stacked bar chart in excel? I am trying to modify the timeline template available here so that my labels for ...
0 votes
1 answer
213 views

Linking a table to a pie chart and basing that chart on certain criteria

I need to create a pie chart from the numbers in this table: But I first need to sort them into categories like this: It needs to be linked so the pie chart would update if the numbers change. Any ...
0 votes
1 answer
3k views

Date as X-axis in Excel

Excel "latest" version (very recent at least, with the Ribbon interface, 2018). Fighting with dates to be used as X-axis labels in a chart. The data below came out of a Pivot table; when selecting ...
0 votes
1 answer
628 views

Excel 2007 Graph scale showing blank dates

I have the below data: Date Planned Complete Carry Over 11-May-18 1 0 1 15-May-18 3 0 3 16-May-18 6 0 6 When I insert a Bar Chart, it is ...
1 vote
1 answer
6k views

Changing the interval values on line chart x-axis

I'm plotting two functions onto a line chart, and I need to change the values on the x-axis. The graph is linked at the end of the question, along with the table that the values are sourced from. ...
3 votes
3 answers
44k views

How to use Excel 2010 VBA to set series line color, marker fill, and marker line color

I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...
0 votes
1 answer
3k views

Have Excel Chart only show current month and YTD

I’m currently working on creating a dynamic chart which is updated monthly in accordance with the information imported into the excel file. The table is updated with the information, where the chart ...
0 votes
1 answer
2k views

How to calculate transformed axis values in Logarithmic scale in Excel chart

What is Excel doing exactly when you tick the "logarithmic base 10" box under Format Axis? It is taking log10, and then applying another transformation to get the transformed axis? This is base on ...
0 votes
1 answer
1k views

Create a line graph per minute in Excel

I want to create a graph/chart that shows everything per minute. In Excel normal chart maker, instead of per minute in the graph, it shows it every per 3 minutes: My data: tweets | minute 134 | 2 ...
-5 votes
1 answer
423 views

Missing data from network monitoring graphs [closed]

The graphs cacti is producing are incomplete. What is problem?
0 votes
0 answers
474 views

Excel: how to create pie chart for this multi-row/multi-column table?

Imagine the following table where data is grouped in different ways. Suppose I have drinks that are either alcoholic or nonalcoholic. And then for each of these types I have 3 sub types. For ...
0 votes
1 answer
59 views

Excel chart with many lines

In my dataset we have many groups writing content. We regualarly take a snapshop of the number of words written. Groups work over a five day Monday to Friday period and we're interested to chart their ...
0 votes
2 answers
89 views

All I want to do is chart 2 columns in Excel

Sorry for asking a question more for a StupidUser than a Superuser but I'm at my wit's end. I have one column of dates (x-axis values), and one of transactions (y-axis values). Date Amount 3/...
2 votes
1 answer
2k views

Excel function, exclude dates in chart data source, excel 2010

I am forming a chart from sheet A. Sheet B contains all my data. I want to exclude a specified date(s). Sample data: +---+----------+--------------+--------------+-------------+-------------+-------...
0 votes
0 answers
6k views

Same colour for same category in different graphs in Excel 2016

I would like to know how to fix the colours for a graph in Excel 2016, such that category 1 is always red, category 2 always blue, etc., because I want to draw several graphs, one for each firm I look ...
0 votes
1 answer
153 views

Excel 2010 - Creating a line graph for trend analysis of faults

I have an excel spreadsheet that currently tracks fault reporting in our building. I am looking to do some form of trend analysis ideally to track the faults on the spreadsheet and then display them (...
0 votes
1 answer
169 views

How can I make a proper graph from GTimeReport's google calendar excel file?

With GTimeReport, I downloaded a report of all my activities from google calendar in excel format. The report looks like this: Example of GTimeReport In the column 1 (see picture above) is a list of ...
0 votes
1 answer
279 views

Excel Chart set axis units as 1, 25, 50,

I've not been able to find to a solution for this. I plot some data as an X Y (Scatter) chart and want the horizontal axis to begin at 1 and then show the units which are multiples of 25, i.e the ...
0 votes
1 answer
136 views

Add specific lines in Excel graphic

I have a large set of x- and y-data points in an excel spreadsheet, which describe a Morse Potential. (see the linked picture below). But what's missing are the red lines I have the y-data points for ...
4 votes
2 answers
15k views

Multiple Y-axis labels in Excel 2010 line chart

I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
-1 votes
1 answer
313 views

Plotting rolling 12 month average and quarterly average

I have the below graph that shows monthly availability, quarterly average of the availability and 12 month rolling average. Here, I dont want to quarterly average line graph to be continuous. I would ...
4 votes
1 answer
908 views

Excel chart – massively create two point lines

I want to create a very custom grid for an Excel chart. I am trying to create a grid system like this: It's called a tripartite graph. For the vertical and horizontal gridlines it's easy, I just ...
2 votes
1 answer
22k views

Insert horizontal axis values in line chart

I want to insert the month names in the horizontal axis of a line chart. This should be easy to do, but after for one hour I can't figure out how to do it. This is the sheet that contains the chart ...
3 votes
1 answer
825 views

Subscript in Excel bars

I used chart tools in Excel to draw some bars. As you see, some of the cells that name the categories include subscript characters, but when they appear in the legend, none of the characters are ...
-1 votes
1 answer
263 views

Stacked Bar Graph in Excel or Matlab

I want to represent this graph either in matlab/excel . X-axis show the load on primary network with values ranging 0.0 to 0.9 At Y-axis there is a ratio of NSU/NCH that goes from 0.08 to 0.44 each ...
3 votes
4 answers
75k views

Why can't I add a trendline to a chart in Excel 2007?

I created a really simple chart based on 2 columns (date and numeric value). I click on the chart, go to Chart Tools/Layout. The Trendline drop down is greyed out. What am I missing?
2 votes
1 answer
681 views

How to create a list that looks like a chart legend?

I'm trying to describe the different parts of an image (here, the Sublime Text interface) I've highlighted multiple zones of it with colored rectangles I'm now trying to define what's in each of ...
1 vote
1 answer
366 views

Plot graph with only some values for category

I am trying to graph the table below. Expecting to get one line per color. I have no idea how to set the graph to get the desired result. Header of the table contains category values (X values). ...
1 vote
1 answer
779 views

How to create a histogram (bar chart) to compare items between groups over 3 years?

I would like to plot a bar chart (histogram) to compare the items (X, Y, total) between 2 groups over 3 years using MS Excel 2010. For example, 2016 2017 2018 Group A Item X ...
0 votes
1 answer
3k views

Add data to chart and use the same horizontal axis in Excel

I have created a chart representing a geological profile/cross-section. On the vertical axis you can see the height in metres above sea level and on the horizontal axis you can see the distance in ...
0 votes
1 answer
581 views

How can I hide small values from a graph

I want to show only values of >=2. Is it possible to hide everything below 2 or above -2?
1 vote
2 answers
11k views

Chart Series name referencing cell address Excel 2010 VBA

I am using Excel 2010. I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...

1
13 14
15
16 17
32